mysqlhotcopy fails when "databases = all" (deprecate method?)
The failure is caused by mysqlhotcopy trying and failing to hot-copy the
Debug: su root -c "/usr/bin/mysqlhotcopy --quiet --allowold --regexp /.*/./.*/ /var/backups/mysql/hotcopy" Warning: DBD::mysql::db do failed: command denied to user 'root'@'localhost' for table 'accounts' at /usr/bin/mysqlhotcopy line 523. Warning: Failed to hotcopy all mysql databases
I think with regards to this, the fact that
mysqlhotcopy only supports then MyISAM or ARCHIVE engines, and the InnoDB engine being the default nowadays, I suggest we remove support for mysqlhotcopy from the handler and replace it with support for XtraBackup or MariaDB Backup (the latter being a more featureful fork of the former). Both are packaged in Debian.