如何在MySQL中进行备份? [英] How do I do backups in MySQL?

问题描述

如何在MySQL中进行备份?

How do I do backups in MySQL?

我希望会比每隔"x"小时运行一次mysqldump更好.

I'm hoping there'll be something better than just running mysqldump every "x" hours.

是否有类似SQL Server的功能，您可以在其中每天进行一次完整备份，然后每小时进行一次增量备份，因此，如果数据库死了，您可以还原到最新的备份吗?

Is there anything like SQL Server has, where you can take a full backup each day, and then incrementals every hour, so if your DB dies you can restore up to the latest backup?

类似于数据库日志，只要日志不会消失，您就可以恢复到数据库死亡的确切位置?

Something like the DB log, where as long as the log doesn't die, you can restore up to the exact point where the DB died?

此外，这些东西如何影响锁定? 如果我执行mysqldump，我希望在线交易会被锁定一段时间.

Also, how do these things affect locking? I'd expect the online transactions to be locked for a while if I do a mysqldump.

推荐答案

您可能想看看 查看全文