Simple MYSQL backup method on your server

I am not using mysqldump for backup, because it is used to back up the MYSQL database on the server, as long as all files under DATA are copied directly.

Install MYSQL in E: \ PHPsetup \ mysql \ data, and store the backup file D: \ beifen \ 1; D: \ beifen \ 2; D: \ beifen \ 3; D: \ beifen \ 4; D: \ beifen \ 5; D: \ beifen \ 6; D: \ beifen \ 7, which is set for a period of seven days.

Put deltree into the c: \ windows directory, and put the following content into 1.bat

Net stop mysql

Net stop w3svc

Net stop iisadmin/y

Deltree/y D: \ beifen \ 1 \.

Xcopy/e: \ PHPsetup \ mysql \ data D: \ beifen \ 1

Net start w3svc

Net start mysql

Meaning:

1. Stop the mysql Service

2. Stop the IIS service.

1 2 Next Page