Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
None
-
None
Description
I am facing this issue when try to restore the database that was dumped using mysqldump utility.
This is the command that I am using to take dump of the database
mysqldump --column-statistics=0 -u root --password=${root_password} -h <host> --single-transaction --all-databases
|
now if I try to restore the things using the `.sql` file that is generated by above command, this is the error that I get
ERROR 1556 (HY000) at line 819: You can't use locks with log tables
|
so I tried to exclude the log table that are in mysql database, while taking dump and modified the command to
mysqldump --column-statistics=0 -u root --password=${root_password} -h <host> --single-transaction --ignore-table=mysql.slow_log --ignore-table=mysql.general_log --all-databases
|
and even after this command it looks like the logs tables are there in the backup `.sql` and I get the same error while restore.
I have seen at some places that this error can be ignored. So here are some questions
1. Can/Should we ignore the error that we are getting while restore
2. Why are we not able to exclude log tables from the mysqldump command (this is more related to mysqldump than maria I think)