开发者

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'.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜