Ignore single table with mysqldump?

Question

I have this large database (over 100 tables and 30+ million rows), which is a pain in the ass to import from a full backup.

The problem is that one table contains most of the data (about 27 million rows) and is completely static. So I was wondering if it is possible to specify 1 table to ignore when backing up with mysqldump (instead of listing each table except the one I want to ignore)

Answer 1

Use '- ignore-table = db_name.tbl_name' .