How to import an SQL file via HeidiSQL
Importing a .SQL file is very easy. In this tutorial we show you how to do this.
There are a couple of database manage tools that you could use.
Some examples:
HeidiSQL - Free
Navicat - Paid, trial available
In this tutorial we will use the free HeidiSQL tool
In the menu, click on Databases
Click on the +eye+ button the view your database credentials
The details you see in step 2 are needed to login into HeidiSQL
Open HeidiSQL
We would like to create a new connection if no one exists yet. Click on the New button
Enter the Hostname, User, Password and Port and Click on Open
Click on your database name
Click on Query
Right click on the empty text field and click on "Load SQL File"
You can also copy and paste the content of the SQL file to the empty text fiel
Open the SQL file that you want to import
Click on the play button or press F9
The .SQL file will now import. If you get an error message then something is wrong with the Queries in your SQL file.
Database programs
There are a couple of database manage tools that you could use.
Some examples:
HeidiSQL - Free
Navicat - Paid, trial available
In this tutorial we will use the free HeidiSQL tool
In the menu, click on Databases
Click on the +eye+ button the view your database credentials
The details you see in step 2 are needed to login into HeidiSQL
Open HeidiSQL
We would like to create a new connection if no one exists yet. Click on the New button
Enter the Hostname, User, Password and Port and Click on Open
Click on your database name
Click on Query
Right click on the empty text field and click on "Load SQL File"
You can also copy and paste the content of the SQL file to the empty text fiel
Open the SQL file that you want to import
Click on the play button or press F9
The .SQL file will now import. If you get an error message then something is wrong with the Queries in your SQL file.
Updated on: 02/07/2022
Thank you!