HOWTO: backup / resotre mysql database for drupal

To Backup:

1. select the database need backup in phpMyAdmin
2. select the tab of Export, and save as file in a sql format.

To resotre:

1. upload the drupal installation files into the proper directory.
2. copy the old director of /site/all, in which are the modules and themes to the new site directory. Otherwise some functionalities will miss.
   
3. create the database you want in phpMyAdmin with proper database name.
4. select the new database and Import.
5. Install the new drupal site.