Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
D:\>mysqldump -uuser -ppass dbname > 1.dump.sql.txt
mysqldump: Got error: 1146: Table 'dbname.admin20_cache' doesn't exist when using LOCK TABLES

How to make MySQL ignore the error ?

share|improve this question
did you try to create table named 'admin20_cache' ? – risyasin Jun 1 '10 at 8:06
No,I want it to ignore errors. – db2 Jun 1 '10 at 8:07
up vote 1 down vote accepted

--ignore-table=name Do not dump the specified table. To specify more than one table to ignore, use the directive multiple times, once for each table. Each table must be specified with both database and table names, e.g. --ignore-table=database.table

I think this might be your only option (from mysqldump --help)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.