What is the prefer way to generate mysql backup while application is running ?
在应用程序运行时生成mysql备份的首选方法是什么？
I want to provide functionality to admin to take backup of database at the same time when other admin using the same application from other computer.
我想为管理员提供功能，以便在其他管理员使用来自其他计算机的相同应用程序时同时备份数据库。
What is the prefer way to handling this scenario ?
处理此场景的首选方法是什么？
2 个解决方案
#1
0
Hopefully you can take backup using mysqldump utility without stopping the database. Mysqlworkbench application provides easier interface to do this. If you are looking for a more advanced option and worry about transaction you can set up a replicated server, so that you can take the stable backups without stopping the master server.
希望您可以使用mysqldump实用程序进行备份而无需停止数据库。 Mysqlworkbench应用程序提供了更简单的界面来执行此操作。如果您正在寻找更高级的选项并担心事务，则可以设置复制服务器，以便您可以在不停止主服务器的情况下获取稳定备份。
#2
-2
if you are working on a webserver with php support use phpMyAdmin or any mySQL Dumper
如果您正在使用php支持的网络服务器上使用phpMyAdmin或任何mySQL Dumper
#1
0
Hopefully you can take backup using mysqldump utility without stopping the database. Mysqlworkbench application provides easier interface to do this. If you are looking for a more advanced option and worry about transaction you can set up a replicated server, so that you can take the stable backups without stopping the master server.
希望您可以使用mysqldump实用程序进行备份而无需停止数据库。 Mysqlworkbench应用程序提供了更简单的界面来执行此操作。如果您正在寻找更高级的选项并担心事务，则可以设置复制服务器，以便您可以在不停止主服务器的情况下获取稳定备份。
#2
-2
if you are working on a webserver with php support use phpMyAdmin or any mySQL Dumper
如果您正在使用php支持的网络服务器上使用phpMyAdmin或任何mySQL Dumper