Mysqldump Errors.

While taking a backup from mysql dump i got an error..

mysqldump: Got error: 1044: Access denied for user abc@localhost to database abc when using LOCK TABLES

This is a bug in mysql which is being patched in the newer version however if you still want to backup from the current version you can do

mysqldump -u yourusername -h yourhost -ppassword --single-transaction databasename | gzip -9 > backup.gz

it should do the trick.

Keep in mind immediately after -p is password of the user *no spaces* 

-h = hostname usually localhost

-u = username which have acceess to the databse

~ by azimyasin on September 27, 2007.