mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user – for table ‘cond_instances’

Rob —  July 24, 2014 — 1 Comment

Have you seen this error before? This is because you’re trying to dump the performance_schema database while locking tables.

The full error you received probably looks something like:

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

This probably means you’re trying to backup all of your databases at once.. you don’t need to back up the performance_schema database (and information_schema) anyway – so just exclude it and you won’t see this error anymore!

(Though, there’s a better way to backup all of your mysql databases…)

Related posts from Linux Brigade!

  • Import MySQL database from command lineImport MySQL database from command line You’ll need to import a database via command line from time to time – I’ll normally opt for this anyway. After seeing how easy it is, you’ll probably end up using the command line instead […]
  • Rescued my little Acer C7 ChromebookRescued my little Acer C7 Chromebook After installing chrubuntu on my c7, I decided to put it back to factory and give crouton a try so that I could run both chrome and crouton at the same time.  I created the restore usb […]
  • Warning: Skipping the data of table mysql.event.Warning: Skipping the data of table mysql.event. Your MySQL script was running great, but then you started getting errors – If you get this warning when dumping the mysql database, it’s not a bug – MySQL did this on purpose because they […]
  • Check, repair, optimize all databases with one commandCheck, repair, optimize all databases with one command My server had some tables marked as ‘crashed’ in one of the databases.. the server had recently gone down pretty harshly so I wanted to go through and check, repair and optimize all of the […]
  • Back up all of your mysql databases nightlyBack up all of your mysql databases nightly Have you ever wanted to make your own MySQL database backups?  You can use this script I wrote to make a backup of all databases, then save each one in a dated backup directory.  It will […]

Trackbacks and Pingbacks:

  1. AutoMySQLBackup mysqldump error 1142 | Romand Rails - March 3, 2015

    […] to this site this is because is trying to back up also the “information_schema” and the […]

Leave a Reply

Text formatting is available via select HTML.

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url=""> 

*