MySQL automatic backup (Windows)

Many times, for data security, our MySQL database needs to be backed up on a regular basis, and here are two ways to automate backup under Windows:

1. Copy the date folder backup

============================ Example Environment:mysql   installation location: c: \mysql Forum database name is Cm_ DB database backup destination: C:\db_bak============================ new Db_bak. bat, write the following code

MySQL xcopy C: \mysql\data\cm_db\*.* c:\db_bak\cm_db\%date: ~0,10%\/S/   MySQL

Then use Windows to schedule tasks to perform db_bak.bat regularly

2. mysqldump Backup to SQL file

============== Example Environment:mysql   installation location: c: \mysql Forum database name is cm_dbMySQL root   Password: 123456 database backup destination: D: \db_backup\

@echo"ymd=%date:~,4%%date:~5,2%%date:~8,2%"C: \MySQL\bin\mysqldump--opt -U root--password=123456 cm_db > D:\db_backup\bbs_%Ymd%. sql@ Echo on

Then use Windows to schedule tasks to perform db_bak.bat regularly

MySQL automatic backup (Windows)