Lab Environment:
A total of 2 MySQL servers A and B, on the B remote backup a database on a, set up a database on a Google and Baidu, pay attention to the firewall on the 3306 port or shut down firewalls;
Experimental topology:
Experimental steps
1) Set up a database on a
2) set up a dedicated database user on a, where I use the root account to grant the root account to a 192.168.1.2 connection via a remote host
3) Back up the test on backup Host B
View already backed up successfully
4) write a script on backup Host B before you need to create a backup directory Mkdir-p/opt/beifen
Then write the Script VI mysqlbak.sh
5) do not forget to give the script permission "chmod +x mysqlbak.sh" Before executing the backup script and
Perform:
./mysqlbak.sh
6) View Backup results
7) Set up Scheduled Tasks
Crontab-e
Mysql Remote Automation Backup
