How to fix. mysqldump: Got error: 1142
Error: Things happened
When I tried to backup mysql by automysqlbackup, it showed folloing error message.
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user
'root'@'localhost' for table 'cond_instances' when using LOCK TABLES
How to fix
Exclude 'performance_schema' mysql database that uses PERFORMANCE_SCHEMA storage engine.
/etc/automysqlbackup/automysqlbackup.conf
# List of DBNAMES to EXLUCDE if DBNAMES is empty, i.e. ().
CONFIG_db_exclude=( 'information_schema' 'performance_schema' )
ref.
Can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied for 'cond_instances' - Server Fault
http://serverfault.com/questions/268566/cant-backup-the-mysql-table-with-mysqldump-select-lock-tabl-command-denied-for