开发者

ignore one table with mysqldump?

开发者 https://www.devze.com 2023-01-30 07:28 出处:网络
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.

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

精彩评论

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

关注公众号