database dump and restoration

To create dump of a database, type the following command:

$MYSQLDUMP -u $MyUSER -h $MYHOST -p $MyPASS $db > $FILE

RESTORE :

run MySql administrator -> Restore -> open file (back up) -> Restore.
Fill in the required options.

You can also change/assign the username and password from administrator itself.

It's a bit difficult to do it in ubuntu.
Well, here we go for restoration in ubuntu:

1) open terminal
2) mysql -u username -p
3) create database db_name;
4) change db_name;

close this terminal

5) open a new terminal
6) sudo -u username -p database_name < db_file.dmp;

and we are done with restoration
we can check it by opening a new terminal.