AutoMySQLBackup 2.5.1 reported errors

If you get an error message like

mysqldump: Got error: 1044: Access denied for user ‘backuppc’@’localhost’ to database ‘information_schema’ when using LOCK TABLES

it is due to a bug in AutoMySQLBackup 2.5.1. The ‘information_schema‘ database contains read-only information about the server and there is no need to back it up or restore it. To fix this warning message you can edit the automysqlbackup.sh backup script and add information_schema to DBEXCLUDE on line 76:

DBEXCLUDE=”information_schema”

AutoMySQLBackup will then stop trying to backup this database.

AutoMySQLBackup 2.5.1 reported errors
Share this