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!
$ ./mysqldump -u root -p --all-databases --ignore-database=performance_schema --ignore-database=information_schema
(Though, there’s a better way to backup all of your mysql databases…)
Related posts from Linux Brigade!
- Import 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 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. 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 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 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 […]