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

Advertisements

~ by Azeem on September 27, 2007.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: