How do I ignore errors with mysqldump?
When dumping a database, I'm getting
mysqldump: Couldn't execute 'show create table `some_table`': execute command denied to user 'some_user'@'%' for routine 'some_routime' (1370)
and then the dumping just stops.
How do I make mysqldump continue when it runs into these sorts of problems? 10 minutes of Google has offered no help.
Here is the command I used:
mysqldump -u username -h localhost --port=4406 -p --databases database_name --skip-lock-tables --force > database_name.sql
man mysqldump
-f, --force Continue even if we get an sql-error.
AFIAK, you can't. You need enough privileges to run mysqldump
. Why didn't you give execute
privilege to the user that running?