There was a problem loading the comments.

How to Import and Export a MySQL database using HeidiSQL?

Support Portal  »  Knowledgebase  »  Viewing Article


How to Export a MySQL database using HeidiSQL


First, connect to your database in HeidiSQL.


Replace the Hostname, User, and Password fields with your database server and login details:


Once connected, RIGHT-CLICK on your database name in the left column, and select "Export database as SQL":






On the next screen, enable both "Create" checkboxes, for Output select "One big file", and select a location/filename to save the MySQL dump file to:




You will now have a file saved to your hard drive that can be used to restore your database.



How to Import a MySQL database using HeidiSQL


 To import a database from a .sql dump file, connect to your new database using HeidiSQL.


Select your database, and then then from the TOOLS menu, select "Load SQL file..."






This will load your .sql file into the top window.


 To proceed with the import, click the "Run" option:








You should now see your database populated with tables and data:





Share via
Did you find this article useful?  

Related Articles

Self-Hosted Help Desk Software by SupportPal
© Host4u Limited