Problem: already add backup command in cron:
mysql -s -r -u root -e ‘show databases’ -N | while read dbname; do mysqldump -u root --complete-insert --single-transaction “$dbname” > /backup/sql/”$dbname”.sql; done
and add dbusername and dbpassword in ~/.my.cnf
[client] user = dbusername password = dbpassword
but fail to backup due to ‘INFORMATION_SCHEMA.GLOBAL_VARIABLES’ feature is disabled.
According to suggestion, enable MySQL 5.6 compatibility.
Solution: enter MySQL mode and enter
set global show_compatibility_56=on;
or add below directive to /etc/my.cnf :
show_compatibility_56=ON