Can't dump mysql backup file [closed]

Closed. This question is off-topic. It is not currently accepting answers.

---

Want to improve this question? Update the question so it's on-topic for Stack Overflo开发者_开发技巧w.

Closed 11 years ago.

Improve this question

I have created a backup of my database and now I want to dump it in to my local machine. My machine is linux machine and I have th eroot password for machine. I tried to dump the in to my local backup database using root password on ssh, but i keep getting an errror . "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)". Please suggest me what to do

This is the command I am using " mysql < backup.dump.gz"

---

Try:

gunzip < backup.dump.gz | mysql -u root -p

And enter your password when prompted.