Use MySQL Query Browser
I myself often forget to use SQL commands to add privileges, dumping, create databases, etc.. So I prefer to use a GUI application such as MySQL Query Browser or phpMyAdmin. In this book is the example I use MySQL Query Browser. They are used as follows.
1. Download MySQL Query browser at address: http://dev.mysql.com/downloads/
2. Once the download is complete run the installation as usual.
3. After the installation is complete, run the MySQL Query Browser by clicking Start> MySQL> MySQL Query Browser.
4. The first dialog box dialog box to login to MySQL Server Instance will be displayed.
5. In the dialog box enter the MySQL user and password has been made before.
6. For Default Schema, can enter freely. Click the OK button if it is.
7. The next major console will be displayed. To create a new database, right click on the database and click on the option Create Schema
8. The name of the database you want and up to this point the new database has been successfully created.
9. Here is the process of import of the database that was created earlier.
10. Right-click the database you just created and then click on the option Make Default Schema.
11. Click File> Open Script, and select the file. Sql that you want to restore.
12. Now we live Execute to import the file. Sql in database PHP