Restore a database dump in ubuntu server

Question

My problem is that my backup is on desktop of windows and I have to restore it on ubuntu server.So please suggest me any command for restoring. I was used mysql -u xxxx -pxxxx database < x.sql but it cant found this file.

Answer 1

You need to go to ubuntu terminal.

Then type

cd /home/{username}/Desktop/ here username is the username for the machine u can see it inside home

Now u are on Desktop

Then type

mysql -u xxx -pxxxx database < x.sql