> ## Documentation Index
> Fetch the complete documentation index at: https://help.freakhosting.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to Import SQL Files with HeidiSQL for FiveM

> Master remote database interaction. Learn how to manage your FiveM database, import script tables, and edit player data using the HeidiSQL client.

## Technical Database Interaction

While the [FREAKHOSTING Game Panel](/games/fivem/how-to-setup-your-database-on-your-fivem-server) provides the underlying network connection, **HeidiSQL** is the industry-standard desktop client utilized to actually interact with your persistent data. This powerful, lightweight tool is essential for administrators who need to import `.sql` files for complex resources (such as job systems or dealership scripts) and for performing manual adjustments to player bank balances, inventory items, or administrative ranks.

<CardGroup cols={2}>
  <Card title="Difficulty" icon="gauge-low">
    Intermediate
  </Card>

  <Card title="Time" icon="clock">
    6 Minutes
  </Card>
</CardGroup>

***

## Step 1: Establishing a Remote Connection

Follow these steps to link your local machine to your hosted database instance.

<Steps>
  <Step title="Acquire the Client">
    Download and install the latest stable version of [HeidiSQL](https://www.heidisql.com/).
  </Step>

  <Step title="Initialize Session">
    Launch the application and click **New** to create a connection profile.
  </Step>

  <Step title="Input Credentials">
    * **Network Type:** Select `MariaDB or MySQL (TCP/IP)`.
    * **Hostname / IP:** Enter your Database Endpoint (Found in the panel's **Databases** tab).
    * **User / Password:** Input your specific database credentials.
    * **Port:** use the default `3306`.
  </Step>

  <Step title="Open the Tunnel">
    Click **Open**. The application will establish a secure connection and display your database structure in the left-hand sidebar.
  </Step>
</Steps>

***

## Step 2: Importing Resource Data

Complex FiveM scripts often include a `.sql` file (e.g., `esx_vehicleshop.sql`) designed to initialize the necessary tables and relationships.

<Steps>
  <Step title="Select Target Registry">
    In the HeidiSQL sidebar, click on your server's database name to set it as the active context.
  </Step>

  <Step title="Open SQL Asset">
    Navigate to **File** -> **Run SQL file...** and select the `.sql` file provided with your modification.
  </Step>

  <Step title="Execute Logic">
    If a "Query" tab initializes, press the **Execute (Blue Play button)** or **F9**. The script will now programmatically build your database tables.
  </Step>

  <Step title="Verify Installation">
    Right-click your database and select **Refresh**. New entries should now be visible within the table hierarchy.
  </Step>
</Steps>

***

<Important>
  ### Data Preservation Protocol

  Executing a `.sql` file can be a destructive action if the script contains `DROP TABLE` or `REPLACE` commands. We strongly recommend using the **Export** feature within HeidiSQL to create a local dump of your data before importing major framework updates.
</Important>

***

<Note>
  ### Need Extra Help?

  If you encounter any issues, our support team is ready to assist:

  * **Live Chat:** Quick assistance via our website.
  * **Support Ticket:** [Open a Ticket](https://freakhosting.com/clientarea/submitticket.php)
  * **Discord:** [Join our Community](https://discord.gg/freakhosting)
  * **Email:** [support@freakhosting.com](mailto:support@freakhosting.com)
</Note>

<Tip>
  ### Save on Your Hosting

  Ready to get a new server? Use code **KB20** at checkout for **20% off** your first month!
</Tip>

***

<div align="center">
  **Last Updated:** January 2026 | **FiveM:** Database managed.
</div>