Instructions for backing up MySQL data with Linux crontab+xtrabackup automation

1.xtrabackup backup may not be a problem, but if it is executed in crontab, there may be unsuccessful execution, the error example is as follows

Innobackupex:Error:mysql child process had Died:sh:mysql:command not found

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6D/38/wKioL1Ve06Pww1V6AADV-7CLCNQ562.jpg "title=" 1.png " alt= "Wkiol1ve06pww1v6aadv-7clcnq562.jpg"/>

Workaround 1:

ln-s/usr/local/mysql/bin/mysql/usr/bin/mysql

Workaround 2:

Introducing environment variables in backup scripts

Source/etc/profile

This article is from the "Everyman" blog, please make sure to keep this source http://caoyt.blog.51cto.com/9978141/1653876

Instructions for backing up MySQL data with Linux crontab+xtrabackup automation