CODEWITHSUNDEEP
backupinnodbmysql
triclosan
triclosan

Reputation: 5714

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?

Upvotes: 1

Views: 12068

Answers (1)

powerMicha
powerMicha

Reputation: 2773

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

Upvotes: 2

Related Questions