1. Problem description:
When performing a MySQL database backup, the following error message is received in the backup report:
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */* FROM `GLOBAL_STATUS`': The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled: see the documentation for 'show_compatibility_56' (3167)
2. Cause:
show_compatibility_56 is deprecated
3. Resolution:
Run the following query in your MySQL database:
set @@global.show_compatibility_56=ON;