How to backup & restore mysql using HeidiSQL


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.

Last update:
2015-10-24 07:04
Author:
Bytehouse Technical Support
Revision:
1.4
Average rating:0 (0 Votes)

You cannot comment on this entry

Chuck Norris has counted to infinity. Twice.

Records in this category

Tags

top