Steps for automatic MySQL backup in Windows: 1. Stop the MYSQL service. 2. Copy the pm project data file to the current date folder under "D: MySQL_BAKpm. 3. Call winrar to compress the copy folder. 4. Delete the copy folder and retain only the compressed files. 5. Start the MYSQL service. @ Echooffnetstopmysqlxcopy
Steps for automatic MySQL backup in Windows: 1. Stop the MYSQL service. 2. Copy the pm project data file to the current date folder under "D: \ MySQL_BAK \ pm. 3. Call winrar to compress the copy folder. 4. Delete the copy folder and retain only the compressed files. 5. Start the MYSQL service. @ Echo offnet stop mysqlxcopy
Automatic MySQL backup in Windows
Main steps:
1. Stop the MYSQL service.
2. Copy the pm project data file to the current date folder under "D: \ MySQL_BAK \ pm.
3. Call winrar to compress the copy folder.
4. Delete the copy folder and retain only the compressed files.
5. Start the MYSQL service.
@ Echo offnet stop mysqlxcopy "D: \ MySQL Server 5.1 \ data \ pm \ *. *" D: \ MySQL_BAK \ pm \ % date :~ 0, 10% \ "/y" D: \ Program Files \ WinRAR \ WinRAR.exe "a-k-r-s" D: \ MySQL_BAK \ pm \ % date :~ 0, 102.16.rar "" D: \ MySQL_BAK \ pm \ % date :~ 0, 10% "rd" D: \ MySQL_BAK \ pm \ % date :~ 0, 10% \ "/S/Qnet start mysql