SQL2000/Mysql automatic backup code

We will provide a database automatic backup code, which is very simple as long as we do it step by step.

We will provide a database automatic backup code, which is very simple as long as we do it step by step.

Put the following files in the system32 directory,
Then, use the notebook to open
Backupsql. bat
Replace
"E: Location of the Data Directory of the database where SQL2000 is located *.*"
Change to your own SQL2000 data directory, as shown in figure
"E: Program FilesMicrosoft SQL ServerMSSQLData *.*"
Then
"E: Location of the Data Directory of the Mysql database *.*"
Change to your Mysql data DIRECTORY, for example:
"E: Program FilesMySQLMySQL Server 5.0data *.*"
After saving,
On the Control Panel of the server, you can schedule tasks,
After you add a scheduled task and call backupsql. bat to run the task, you can implement scheduled backup. By default, the files generated by the backup are saved on the edisk. You can modify backupsql. bat to modify the location.

@ Echo off
C:
CD "C: Program FilesWinRAR"
Net stop MSSQLserver
Winrar.exe a-ag "-[YYYY-MM-DD-HH-MM-SS]"-k-r-s-ibck-inul "E: file generated by sql200020..rar" E: Location of the Data Directory of the database where SQL2000 is located *.*"
Net start MSSQLserver
Net stop Mysql
Winrar.exe a-ag "-[YYYY-MM-DD-HH-MM-SS]"-k-r-s-ibck-inul "E: file generated by mysqlbench. rar" E: Location of the Data Directory of the Mysql database *.*"
Net start Mysql