Excluding specific tables w/ mysqldump 1

[bioinf]

Hi,

I have a db with 84 tables running on MySQL 3.23.52. I want to clone about 81 of the tables and exclude the last 3. Two of these 3 are huge, so it would speed up the cloning conisderably (and keep the server admin folks happier). I looked in my MySQL textbook and didn't see any good options--and searched the forum as well. Is there a simple way of excluding specific tables using mysqldump?

many thanks

 

[sleipnir214]

There is no way to exclude a particular table from a dump. The only thing you can do is selectively explicitly include the other tables in your invocation of mysqldump.

It will be ungainly, but the only way to do it is to name the other 81 tables.


Want the best answers? Ask the best questions!

TANSTAAFL!!