Buy Percona ServicesBuy Now!

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

  • 5.5.8-20.0 mysqldump option --ignore-create-error introduced
Visit Percona Store

General Inquiries

For general inquiries about our open source software and database management tools, please send us your question and someone will contact you.