MySQL remote backup script

When a remote server backs up Mysql, the remote server does not have a Mysql database installed, and the backup mysqldump command cannot take effect. Therefore, you can install the mysql database

When a remote server backs up Mysql, the remote server does not have a Mysql database installed, and the backup mysqldump command cannot take effect. Therefore, you can install the mysql database

When a remote server backs up Mysql, the remote server does not have a Mysql database installed, and the backup mysqldump command cannot take effect. Therefore, you can copy the mysqldump.exe (for example, mysqldump.exe in C: \ Program Files \ MySQL Server 5.0 \ bindirectory) installed in the mysqldata Library Server to a directory on the remote Server (for example, F: \ MySQLBackup ).

For example, if the file name is PersonBackupMonday. bat, double-click the file. Alternatively, you can use the windows Task Plan to regularly execute the file.

The file content is as follows:

Cd F: \ MySQLBackup

F:

Mysqldump-h ip-uusername-ppassword dbname> F: \ MySQLBackup \ PersonBackupMonday. SQL

Username: Database User

Password: Database password

Dbname: Database Name

Recover data: You can copy the data to the database server.

C: \ Documents ents and Settings \ Administrator> mysql-u username-p

Password: password

Mysql> use dbname;

Mysql> source F: \ MySQLBackup \ PersonBackupMonday. SQL