Hi Everyone,

I am facing an error while using the following command in Putty:

# mysqldump-root DB_NAME >db.sql bzip2 db.sql

I got following error:

mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

I have tried:

# mysqldump-root -p DB_NAME >db.sql bzip2 db.sql

But of no use. I got the same error with (using password: NO)

I have copied "mysqldump-root" from one directory to another directory. Do I need to change the permissions for this new directory? How can I take the dump of mysql database by using mysqldump-root command?

Please suggest..

TIA
Anuj

try

mysqldump-u root -p DB_NAME >db.sql bzip2 db.sql

_________________
Lostboy

Cat, the other other white meat

Please read Posting Etiquette before posting

You can always try Google