LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   mysqldump: dump all tables except.... (https://www.linuxquestions.org/questions/linux-software-2/mysqldump-dump-all-tables-except-649527/)

Niceman2005 06-15-2008 09:34 PM
mysqldump: dump all tables except....
 
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!!


All times are GMT -5. The time now is 09:20 AM.