How to fix the «'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled» Backupninja / Duplicity warning about backup a MySQL database?

mysql-57
duplicity
backupninja
backup
mysql

(Dmitry Fedyuk) #1

== warnings from /etc/backup.d/other-sites–db–1.mysql ==
Info: Initializing SQL dump method
Warning: mysqldump: Couldn’t execute 'SELECT /*!40001 SQL_NO_CACHE node_modules/ sh/ 2017-05-18-18-01.sql backup_authorized_keys backup.sh dotdeb.gpg dump-2.sh mysql-apt-config_0.6.0-1_all.deb mysql-apt-config_0.6.0-1_all.deb.1 node_modules sh FROM GLOBAL_STATUS': The ‘INFORMATION_SCHEMA.GLOBAL_STATUS’ feature is disabled; see the documentation for ‘show_compatibility_56’ (3167)
Warning: Failed to dump mysql databases information_schema


(Dmitry Fedyuk) #2

To fix it, add the show_compatibility_56 = 1 option to the [mysqld] section of the MySQL configuration file (/etc/mysql/my.cnf).