Seeing the following error message after apparently successful run:
###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user
'user'@'host' for table 'cond_instances' when using LOCK TABLES
I saw a few bugs with varying workarounds, and wanted to submit this here, to see if it was resolved within the AutoMySQLBackup code itself. Some workarounds talk about using the --skip-add-locks option to mysqldump, while others talk about excluding the database performance_schema, which appears to be fixed in one or more distributions, but not in the release I just downloaded from SourceForge.
Links to bugs:
mysql Ver 14.14 Distrib 5.5.20, for Linux (x86_64) using readline 5.1
mysqldump Ver 10.13 Distrib 5.5.20, for Linux (x86_64)
Please let me know if you need any additional information.
Log in to post a comment.