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