Ignoring missing tables in mysqldump

In case table name was changed during the mysqldump process taking place, mysqldump would stop with error:

Couldn't execute 'show create table testtable'
Table 'testdb.tabletest' doesn't exist (1146)\n")

This could happen if mysqldump was taking a backup of a working slave and during that process table name would get changed. This error happens because mysqldump takes the list of the tables at the beginning of the dump process but the SHOW CREATE TABLE happens just before the table is being dumped.

With this option mysqldump will still show error to stderr, but it will continue to work and dump the rest of the tables.

Version Specific Information

  • 1.0.6-rel10.1 mysqldump option --ignore-create-error introduced

Contact Us

For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.