Note: mysql port should be opened in server firewall to use HeidiSQL
Connecting to mysql using HeidiSQL
1. Download & install HeidiSQL from the link given below.
http://www.heidisql.com/download.php
2. Open HeidiSQL
3. Click "New". Fille the details and press "Open"
4. Now, we can see HeidiSQL interface as shown below.
Restoring/importing database using HeidiSQL
1. Select database which need to be restored
2. Now, go to File >> "Load SQL"
3. Select the backup file that need to restored.
4. Press Open button
5. Now, we can see following message.
6. Make sure to Press "NO". We really meant No !
7. Now, we can see that SQL is loaded in query window
8. Now, press "Run button" to restore database.
9. Wait for a few minutes
10. Now, we can see that database is restored
11. Press fresh to see tables.
Backing up/exporting database using HeidiSQL
1. Select database which need to be restored
2. Now, right click database. We can see following menu.
3. Press "Export database as SQL"
4. Now, we can see following window
5. Press "Save" button to browse backup location & to give a backup name
6. Now, we can see following.
7. Now, press export to save backup of database.