Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
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

1 Answer 1

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

 
discard

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