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
Percona Server
Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Table Of Contents

Previous topic

Fast Shutdown

Next topic

Too Many Connections Warning

This Page



© Copyright Percona LLC and/or its affiliates 2009-2013.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.1.3.
This documentation is developed in Launchpad as part of the Percona Server source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>