MySQL – Ignore Tables from Backup Question – How do I skip certain tables from MySQL database backup? You can use –ignore-table option with the mysqldump command to ignore table for backup. Using this option, you need to specify both the database and table names as showing in the below example. mysqldump -u root -p DB_NAME –ignore-table=DB_NAME.table1 > database.sql To ignore multiple tables specify the option per table. mysqldump -u root -p DB_NAME –ignore-table=DB_NAME.table1 –ignore-table=DB_NAME.table3 > database.sql
Read More