How to Import SQL Files with HeidiSQL for FiveM

How to Connect to Your FiveM Database with HeidiSQL | EUGameHost

Use HeidiSQL to connect to your FiveM database, import .sql files, and manage player data.

This is useful for:

• importing script databases
• editing player money
• changing job ranks
• fixing inventories
• installing new resources

Difficulty: Intermediate
Time Required: 6 Minutes

Step 1: Install HeidiSQL

Download and install HeidiSQL on your computer.

Once installed, open the application.

Step 2: Create a New Connection

Click:

New

Create a new session.

Use the following settings:

Network Type: MariaDB or MySQL (TCP/IP)
Hostname / IP: Your database host
Port: 3306
Username: Your database username
Password: Your database password

You can find these details in your EUGameHost Game Panel under:

Databases

Step 3: Connect to the Database

Click:

Open

HeidiSQL will connect and show your database on the left side.

Click your database name to expand the tables.

Step 4: Import a Script SQL File

Many FiveM resources include an .sql file.

Example:

esx_vehicleshop.sql

To import it:

Go to:

File > Run SQL file...

Select the .sql file included with your script.

Then click:

Execute

or press:

F9

This will create the required tables automatically.

Step 5: Refresh the Database

After importing, right-click your database and click:

Refresh

The new tables should now appear.

Example tables may include:

users
owned_vehicles
jobs
items

Editing Player Data

You can also manually edit tables.

Common examples:

• users → money, jobs, rank
• owned_vehicles → vehicle ownership
• player_inventory → items

Always be careful when editing live data.

Important: Create a Backup First

Before importing or editing data, create a backup.

This prevents accidental data loss.

Need Help?

If you have trouble connecting HeidiSQL to your database, the EUGameHost support team can help verify your connection details.