1. Home
  2. SQL
  3. FAQ
  4. Skip tables in mysqldump

Skip tables in mysqldump

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
Tags ,
Was this article helpful to you? Yes 3 No
Advertisement