Let's Share Our KNOWLEDGE

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 and we are done with restoration we can check it by opening a new terminal.