There are many methods on the Internet about automatic backup of Mysql under window, but few of them are really usable. Some of them are very complicated and difficult to operate. Here is the editor of Script House. We have shared and compiled several software for everyone to use
There are many methods on the Internet about automatic backup of Mysql under windows, but few of them are really usable. Some of them are very complicated and difficult to operate. .
We all know that mssql itself comes with scheduled tasks that can be used for automatic backup. But how can we automatically backup mysql?
Teach you the simplest method.
This method is done using bat batch processing.
Imaginary environment: MySQL Installation Location: D:\Program Files\MySQL\MySQL Server 5.0\data
As shown in the picture:
The database name is: 952game database backup destination: d:\db_bak\ (the path to which disk you want to back up the database to) I If you want to prepare it under the db-bak directory of the D drive================================== Create a new db_bak.bat and write the following code
net stop mysql xcopy c:\mysql\data\bbs\*.* d:\db_bak\bbs\%date:~0,3%\ /y net start mysql
Detailed explanation in the picture:
Domestic Windows server users can use:
Guardian God backup software free version (sqlserver, automatic file backup)
Please use the platform p8net mysql management tool MyAdmin v1.0 (mysql scheduled backup tool)
The above is the detailed content of How to realize automatic scheduled backup of mysql database under windows server. For more information, please follow other related articles on the PHP Chinese website!