Is it possible to make mysqldump skip the inserts for specific table?

Question

I'm regularly running `mysqldump` against a Drupal database and man, those cache tables can get huge. Considering that the first thing I do after reloading the data is clear the cache, I'd love it if I could just skip dumping all those rows altogether. I don't want to skip the table creation (with --ignore-tables), I just want to skip all those rows of cached data. Is it possible to tell `mysqldump` to dump the `CREATE TABLE` statement skip the `INSERT` statements for a specific set of tables?

Accepted Answer

You have to call `mysqldump` twice.

The mysql-stripped-dump script does exactly this.

Is it possible to make mysqldump skip the inserts for specific table?

Solution

Problem