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!
|
1 |
$ ./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 […]
Manually run ClamAV on cPanel and check every user If you’re running WHM/cpanel and want to run a scan on every user manually, perhaps when first installing ClamAV, you’ll want to run this command which is endorsed by cPanel […]
CentOS 7 / RHEL 7 systemd commands By now, if you’ve played around with CentOS 7 (or RHEL 7), you’ve heard that there are now systemd commands you can start using to start, restart and stop various services. They still […]
Can’t afford a full time Linux admin? If you’re just starting out, it’s tough being able to afford full time Linux support. Why not employ Hosting Support Services instead? We’re Red Hat certified, fluent with Red […]
