Mysql5.7 regularly back up databases in the CentOS environment

Let's create a directory dedicated to the backup files for MySQL. /data/mysql_bak. Write a shell script that backs up the test once every minute.

Script code:

755 /testdir/backup.sh       //Give script permission

Then perform a timed task

* * * * * * */usr/sbin/ntpdate pool.ntp.org >/dev/null2>&1*/1 * * * * * */data/mysql_bak/mysql_bak.sh    // This is used to backup every minute

Service Crond Restart   // habitual Restart services　　　　　　　　　　

Refresh the directory every few minutes to view the files.

Ok. Some formatting commands for timed tasks Please refer to this link for detailed instructions.

Additional information about the deletion of old data, you can refer to some other online posts, this article does not explain the HA ~

Http://www.cnblogs.com/wt645631686/p/6868672.html

Mysql5.7 regularly back up databases in the CentOS environment