Nagios Support Forum

Hello,
I am getting the following error on my nightly backup job.

###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES

Is this to be expected or do I need to take some action on this? Thanks,
Jeff

I believe this may be a bug in MySQL found in this thread
http://support.nagios.com/forum/viewtop ... 626#p32702

lmiltchev wrote:This has been reported as a bug:

http://bugs.mysql.com/bug.php?id=21527

Can you run the following command and show the output?

Code: Select all

mysql --version

here you go.

# mysql --version
mysql Ver 14.14 Distrib 5.1.52, for pc-linux-gnu (i686) using readline 5.1

In reading up on this and talking it through with other developers here, this script shouldn't backup information_schema

You can correct this by doing the following:

change line 66 of /root/scripts/automysqlbackup
from to

ok I made the change and will check it tomorrow, thanks.

ok Looks like that was successful. Backup completed normally.