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 […]
Lock down your SSH port/access The instant a Linux server is connected to a public network it starts getting hit by attackers. There are people out there running programs constantly against IP ranges and they’ve hit […]- Understanding cron job times Often, you’ll want to use cron to schedule daily, weekly, hourly (etc…) tasks on your linux system(s). cPanel has a little GUI for it, but since I don’t trust GUIs very often, I like […]
LFD: Excessive resource usage If you run the CSF/LFD firewall on your server then you’ve no doubt seen the emails complaining about high resource usage for various accounts. This small tutorial will show you how to […]
