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)
Use '--ignore-table=db_name.tbl_name'.
精彩评论