How to ignore tables from mysqldump

The mysqldump is a backup program in mysql. It can be used to dump a database or a collection of databases for backup.

This article explains the steps to ignore certain tables from mysqldump.

We can use –ignore-table option with the mysqldump command to ignore table for backup. Here we need to specify both the database and table in the commandline.

#mysqldump -u root -p DB_NAME --ignore-table=DB_NAME.table_name > DB_NAME.sql

To ignore multiple tables,

#mysqldump -u root -p DB_NAME --ignore-table=DB_NAME.table1 --ignore-table=DB_NAME.table3 > DB_NAME.sql

That's all...

Leave a Reply