Skip certain tables with mysqldump

Is there a way to restrict certain tables from the mysqldump command?

For example, I’d use the following syntax to dump only table1 and table2:

mysqldump -u username -p database table1 table2 > database.sql

But is there a similar way to dump all the tables except table1 and table2? I haven’t found anything in the mysqldump documentation, so is brute-force (specifying all the table names) the only way to go?

1Best Answer
11

Leave a Comment