mysqldump: dump all tables except....

Niceman2005 · 06-15-2008, 09:34 PM

Dear friends,

Any idea how to do mysqldump all tables except certain exception?

Say i have a database TEST with tables A, B , C

I wish to mysqldump all tables in TEST except A, is there a command to do so?
I only found a command to say dump A and ignore the rest, i.e with mysqldump --add-drop-table.

thanks for helping!

forrestt · 06-16-2008, 02:11 PM

From the man page for mysqldump:

Code:

+---------------------------------------+-------------------------------+-----------------------+------------+
|--ignore-table=db_name.tbl_name        | ignore-table                  | Do not dump the       |            |
|                                       |                               | given table           |            |
+---------------------------------------+-------------------------------+-----------------------+------------+

HTH

Forrest

Niceman2005 · 06-17-2008, 09:37 PM

Thanks forrestt!!