I like backupninja because of simplicity. Unfortunately it started giving me this problem:
Warning: mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */
dead.letter FROMGLOBAL_STATUS
': The
'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the
documentation for 'show_compatibility_56' (3167)
It looks like this can be fixed with set @@global.show_compatibility_56=ON
. Unfortunately that doesn't work on my MariaDB instance:
Welcome to the MariaDB monitor. Commands end with ; or \g. Your
MariaDB connection id is 73 Server version: 10.1.26-MariaDB-0+deb9u1
Debian 9.1Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.MariaDB [(none)]> set @@global.show_compatibility_56=ON;
ERROR 1193 (HY000): Unknown system variable 'show_compatibility_56'
What else can I try to resolve this?
Best Answer
This has been fixed so a later version (>1.0.2) of
backupninja
will likely resolve your issue.