#71 After run: WARNING - mysqldump: Got error: 1142

[Amarand]

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

CentOS: 2.6.32-279.9.1.el6.x86_64

mysql-5.5.20-1.el6.remi.x86_64
mysql-libs-5.5.20-1.el6.remi.x86_64
libmysqlclient15-5.0.77-1.1.w5.x86_64

automysqlbackup-v3.0_rc6

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:

http://serverfault.com/questions/268566/cant-backup-the-mysql-table-with-mysqldump-select-lock-tabl-command-denied-for
http://bugs.mysql.com/bug.php?id=61414
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=673257

mysql --version
mysql Ver 14.14 Distrib 5.5.20, for Linux (x86_64) using readline 5.1

mysqldump --version
mysqldump Ver 10.13 Distrib 5.5.20, for Linux (x86_64)

Please let me know if you need any additional information.

Thanks!