how do I stop automysqlbackup throwing LOCK TABLES error?

Question

How to stop automysqlbackup's cron.daily script -- as installed and configured from apt-get install automysqlbackup -- throwing the following error:

 mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 
'debian-sys-maint'@'localhost' for table 'cond_instances' when using LOCK TABLES

This first occurred (for me) after having upgraded to MySQL 5.5 as a consequence of having upgraded to Ubuntu 12.04 LTS.

Answer 1

According to this bug report it is necessary to stop automysqlbackup dumping the 'performance_schema' database, and this is done by editing /etc/default/automysqlbackup as follows:

Add an additional pipe to grep step to remove the 'performance_schema' from the list of DBNAMES.

So, in the line that starts DBNAMES=, and after | grep -v ^mysql$ insert

| grep -v ^performance_schema$ 

before | tr \\\r\\\n ,\

Thanks to Jérôme Drouet