ignore one table with mysqldump?

I have this big database (100+ tables and 30+ million rows) that is being a pain in the ass to import back from a full backup.

Problem is that one table contains most of the data (about 27 million rows) and is entirely static. So I was wondering if it was possible to specify 1 table to ignore when creating a backup with mysqldump (instead of listing every table but the one I want to ignore)

7
задан Charles 9 December 2010 в 19:45
поделиться