Dumping
mysqldump -u root -p dbname > /home/dbname_dump.sql

Restore
mysql -u root -p dbname < /home/dbname_dump.sql

mysql> set password for root@localhost=password(‘rootpasswd’);
mysql> create database dbname;
mysql> grant all on dbname.* to root;
mysql> grant all on dbname.* to root@localhost;
mysql> grant all on dbname.* to user;
mysql> grant all on dbname.* to user@localhost;
mysql> set password for user@localhost=password(‘userpasswd’);