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.6.5-60.0 mysqldump option --ignore-create-error introduced

Table Of Contents

Previous topic

Restricting the number of binlog files

Next topic