how to backup and restore database in mysql

MySQL is one of the most famous opensource database. To transfer the database from one system to another you need to take the backup of the database from the source system and restore it on the target machine.  In this post i am going to explain how to backup and restore a database on MySQL database.
Ads by Google 

---

---

First you need to install the MySQL GUI tool called the MySQL Query browser for make this process easier. You can download it from here.

Steps for backup a database.

Step 1:
           Login on MySQL Query browser.

Step 2:
           Click the Tools option on the menu bar and choose MySQL Administrator.

Step 3:

         Select the Backup option from the MySQL Administrator window. 

  

Step 4 :
        Click the 'New Project" button at the bottom of that window and select the database / databases you want to backup and add them into the backup content.

Step 5:

         Click the "Execute Backup Now" button at the bottom of that window and save the backup file in any location of your computer.

Steps for restore a database.

Step 1:
          Follow steps 1 & 2 given above.

Step 2:
          Select the restore option.

Step 3:

       Click the "Open Backup File" button at the bottom of the window and choose the backup file. If the file is not shown the choose the all file type.

Step 4 :

           Finally click the "Start Restore" button. After the restore refresh the database you can see that the database restored successfully. 

Watch Video Tutorial of this Topic