开发者

mysqldump vs innodb hot-backup

开发者 https://www.devze.com 2023-03-20 09:49 出处:网络
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.

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

精彩评论

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