Importing a .SQL file is very easy. In this tutorial we show you how to do this.
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
Login on your game panel
In the server overview, click on the name of your server

To get your MySQL login credentials, In the menu, click on Databases

Find your database credentials
How to find your database name
How to find your database user: Click on the eye button
How to find your database password: Click on the eye button
How to find your database IP/host: Click on the eye button
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

If there is any text like USE `essentialmode` inside the SQL file. You will have to change essentailmode to the name of your database
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
Login on your game panel
In the server overview, click on the name of your server

To get your MySQL login credentials, In the menu, click on Databases

Find your database credentials
How to find your database name

How to find your database user: Click on the eye button

How to find your database password: Click on the eye button

How to find your database IP/host: Click on the eye button

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

If there is any text like USE `essentialmode` inside the SQL file. You will have to change essentailmode to the name of your database
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.
Published on: 06 / 02 / 2020