How to dump a mysql database excluding some tables ?

[Benj]

Hi, how can I dump a mysql database, but excluding some tables ?

Thanks,
Benj

[dank]

You could use phpMyAdmin, click on the appropriate database, click on the Properties link for any desired tables, then do a dump for each such table.

If you have more tables you want to exclude than include, that would work fine.[nbsp][nbsp]Otherwise, I would think you'd be better off dumping the whole database and cutting out the pieces you don't want.

Of course, there may actually be a way to do what you want...[nbsp][nbsp]:)

Dan

[Justin]

Or, you can just specify the tables you want to dump on the command line. The best advice I can give is to read the man page for mysqldump, or just type 'mysqldump --help'. Either way will give you the information you need.

------------------
Justin Nelson
SFE Software (http://www.sfesoftware.com)