Mysqldump for all except one table


I am using mysqldump --opt -u username -p databasename table1 table2 table3 ... to create a dumo of my database for specific tables.

However, now, I want to take backup of whole database (55+ tables), except 1

what is the optimal way to issue the mysqldump without listing 54 table names (excluding one table in the database)
nainilAsked:
Who is Participating?
 
computerstreberCommented:
You can use the "--ignore-table=name" switch in your mysqldump statement.
0
 
computerstreberCommented:
FYI - 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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.