Month: June 2013

ERRORS REPORTED: mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user ‘root’@’localhost’ for table ‘cond_instances’ when using LOCK TABL

  • Add –skip-add-locks(–skip-lock-tables) to your mysqldump command
  • For automysqlbackup on Debian:
    Edit the automysqlbackup executable.
    Modify the function dbdump.
    Add the –skip-lock-tables.
    “ERRORS REPORTED: mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user ‘root’@’localhost’ for table ‘cond_instances’ when using LOCK TABL”Continue reading
Scroll to top