开发者

mysqldump vs innodb hot-backup

I need to perform a backup of entire innodb-database into local file with possibility to restore data from it. Currently I use MySQL Community Edition, but it doesn’t have innodb hot-backup features.

So I’m wondering, which negative aspects should I expect using mysqldump for hotbackup开发者_运维百科 instead of innodb hot-backup features?


Have a look at:

http://dev.mysql.com/doc/refman/5.1/en/innodb-backup.html

I think that the mysqldump is locking each table during the dump process. There should be no limitation in restoring the data, because you will get the data as SQL files

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜