ZAP-Hosting Docs

ZAP-Hosting Docs

  • Docs
  • Languages iconEnglish
    • Deutsch

›Resources & Mods

Overview

    First Steps

    • Register
    • Contract or Prepaid
    • Preorders
    • Community offers
    • Submit Suggestions

    Support

    • Report problems
    • Create Screenshots

Account

  • Contracts & Prepaids
  • Termination and Cancellation
  • Payment options
  • Two-Factor-Authentication
  • Backup Storage
  • Refer a Friend
  • Cashbox
  • User Management
  • Coupons & Codes
  • Donations
  • Community ads
  • Safety
  • Partner

    • Partner System
    • Partner Guide
    • Use of logo and name

Gameserver - General

  • Cloud vs. Lifetime
  • Resource limit
  • Change the game
  • Up-/Downgrade
  • Databases

    • PHPMyAdmin
    • External database access
  • FTP File Access
  • Restart planner
  • Backups
  • Server crash - What to do?
  • TEBEX Monetization

vServer & Rootserver

  • Rootserver versus vServer
  • What is VNC (Serial console)?
  • Network analysis MTR/WinMTR
  • Linux

    • Initial access (SSH)
    • SFTP Connection
    • SSH Key
    • Two factor authentication
    • Change Password
    • Install Java
    • MariaDB (MySQL) Installation
    • phpMyAdmin
    • FTP Setup
    • FTP Service isn't working
    • Docker
    • Plesk
    • OpenVPN
    • Gameserver / Ts 3 Server Interface
    • Nextcloud
    • Add IPv4 Address
    • SSL-Certificate (Let's Encrypt)
    • Rsync Linux
    • Jitsi Meet
    • Install webserver
    • Linux Remotedesktop (xRDP)
    • Cockpit

    Windows

    • Initial access (RDP)
    • Port Forwarding
    • Add additional IPs
    • No Internet what now?
    • FTP Server Installation
    • MySQL Server Installation
    • Plesk Installation
    • Add/change language
    • Extend disk
    • Farming-Simulator 2019
    • Farming-Simulator 2022
    • V-Rising

Dedicated Server

  • iLO
  • Own ISO
  • Windows Installation
  • Install Debian
  • Install Ubuntu
  • Install FreebSD
  • Install CentOS
  • RAID Configuration
  • Server reset

Webspace & Domains

    Domain

    • What is a domain?
    • Order a domain
    • EasyDNS
    • ProfiDNS
    • ExpertDNS
    • Domain Records
    • Domain Gameserver Redirect
    • Domain TeamSpeak 3 Redirect

    Webspace

    • Add Domain
    • FTP Connection
    • Sending Emails
    • Create SSL Certificate
    • Discord forwarding via domain
    • Install MyBB
    • Install WordPress

Voicebot/Voiceserver

  • Voicebot Connection
  • Become Admin
  • Server configuration
  • Ts3 Backup
  • Teamspeak Query Login

Minecraft

    Administration

    • General commands
    • OP-Permissions
    • Server Config
    • Server Icon
    • Add your own world
    • Manage Worlds
    • Behavior/Resource Packs Installation
    • RCON
    • Whitelist
    • Timings-Report
    • Minecraft-Server Optimization

    Spigot & Bukkit

    • Plugin Uploader

    Bungeecord

    • Server Properties

    Forge

    • Mods Installation

FiveM

  • Dashboard
  • Upvotes
  • Configuration & Administration

    • Change Server Icon
    • Emojis in server name
    • Coloured Servername
    • Use Rcon
    • Own License Key
    • Delete Cache
    • Use Profiler
    • Configure Activity Feed
    • Resource contains prohibited logic?
    • Server not in Serverlist
    • Activate Devtools
    • Enable DLC Gamebuild
    • Gamechange

    Resources & Mods

    • Resource Installation
    • SQL File Import
    • Install Replace Carmods
    • Install Addon Carmods
    • Loadingscreen installation
    • Install ELS
    • Install EUP

    ESX

    • Deactivate the Inventory (F2)
    • Change Money Icon
    • Become Admin over the Database
    • Disable HUD
    • Add Cars to Dealership
    • Add Job-Garage Cars
    • Change Respawnpoint
    • Edit Locales Files

    Dunko VRP

    • Change Money Icon
    • Remove Speedometer

    txAdmin

    • txAdmin Setup
    • txAdmin Interface

    QBCore

    • Become admin

RageMP

  • Installing packages

Alt:V

  • Resource Installation

Satisfactory

  • Connect to the Server (Experimental)

Terraria

  • Become an admin (tShock)
  • Mod Installation (tModLoader)

Source Games

  • GSL-Token
  • Custom Content
  • Sourcemod / Metamod

    • Installation
    • Become an admin
    • Plugins

    CS:GO

    • Server Configration
    • GOTV

    Counter Strike 1.6

    • Become Admin
    • Install Plugins

    Garry's Mod

    • Garry's Mod Server.cfg Modification
    • Garry's Mod TTT Configuration

ArmA 3

    ArmA 3 Allgemein

    • Server.cfg
    • Install Mods
    • Altis Life Ranks
    • Change game mode
    • Upload your own mission file

ARK

  • Become Admin
  • Install Mods
  • Serverlisting Problems
  • Server Configuration

Assetto Corsa

  • Configure Server
  • Configure Server with Content Manager
  • Install Mods

Assetto Corsa Competizione

  • Become Admin
  • Car Slot Requirement

Barotrauma

  • Become Admin

BeamMP

  • Create an Auth Key
  • Install Mods

Conan Exiles

  • Become Admin
  • Server Configuration

Valheim

  • Connect to a Server
  • Manage Savegames
  • Automated Backups
  • Serverlisting Problems
  • Admin Commands & Cheats
  • Valheim Plus
  • Install plugins (BepInEx)

SCP: Secret Laboratory

  • Become Admin
  • Add new roles
  • Colored Servername
  • Pastebin ID
  • ServerMod

    • Install Plugins

    Exiled

    • Plugins Install

ECO

  • Become Admin
  • Whitelist

Factorio

  • Become Admin
  • Install Mods

Multi Theft Auto

  • Become Admin

Space Engineers

  • Become Admin
  • Install Mods

Unturned

  • Become Admin
  • Workshop Content
  • 1st/3rd Person
  • Whitelist
  • RocketMod

    • Install Plugins
    • Adjust Permissions

Don't Starve Together

  • Create Caves

Empyrion

  • Become Admin

Rust

  • Become Admin
  • Connect via RCON
  • Plugins Install
  • Decay

Among Us

  • Connection to the Server

7 Days to Die

  • Become Admin
  • Install Mods
  • Commands

Avorion

  • Become Admin

Last Oasis

  • Create Realm
Edit

FiveM Server: SQL file import

Importing SQL files into the FiveM database

Many resources for FiveM require entries in the database of your FiveM server to function properly. Therefore it is important to import the SQL files of resources correctly into your database to ensure that the resources can use the required create entries in the database of your FiveM Server.

Not all resources need the import of a SQL file into the database to work! When you download a resource However, in many cases, one or more files with the file extension .sql are enclosed there, these must then be imported into the database.

Preparation and establishment of the database

In the settings of your FiveM Server the option Configure database must be activated at the beginning and the required resource MySQL-Async must be installed, so that a database can be created and used.

image

There you scroll down until you reach the point Configure database and make sure that this is set to yes, configure! Then scroll to the bottom of the page and click Save at the bottom to apply the settings.

image

Now navigate to the menu item Resources and install the resource MySQL-Async there, if this has not already been done.

image

The database is now configured and ready for use.

Preparing the SQL file

In this example the SQL file for the resource es_extended is imported into the database. You open the folder of the resource and find a file with the file extension .sql there, if available.

image

CAUTION: Before importing, open the .sql file with any editor and check if the following lines are present:

image

If this is the case, first remove both lines, otherwise the SQL file cannot be imported.

Declaration The first line tells the database server that a new database with the name essentialmode should be created. But we don't want this because your FiveM gameserver already has a database with another name and we want to use it. The second line tells the database server to use the database with the name essentialmode for the import, but we don't want this either because the existing database is used for the import.

Import the SQL file into the FiveM database

You can access the database of your Fivem game server via the menu item Databases on the left side of the menu.

image

The database itself is managed by the tool phpmyadmin, which you open by clicking on the blue Administer button. on the right side.

image

Arrived in phpmyadmin you first select your database from the list on the left via left click.

The name of your database starts ALWAYS with zap!

image

Your database is currently still empty, this will change shortly. Via the menu item Import in the upper part of phpmyadmin you get to the import options.

image

There you select now over the point Select file your SQL file, this may be maximally 2MB large!

**Tip: For larger SQL files you can use a so called SQL splitter to split a large SQL file into two parts into several small SQL files. An example of a SQL splitter is as follows Pinetools SQL-Splitter.

After you have selected your SQL file, you only have to click on Go to start the import process.

image

If everything worked, you will see some success messages, like on the left side your newly created database contents.

image

You have now successfully imported your SQL file.

← Resource InstallationInstall Replace Carmods →
  • Importing SQL files into the FiveM database
  • Preparation and establishment of the database
  • Preparing the SQL file
  • Import the SQL file into the FiveM database
Rent a Server
Rent a VPSRent a rootserverRent a gameserverRent a TS3 serverRent a Discord MusicbotRent a domainRent a webspace
Social
TwitterInstagramBlogJobsVoucher CodesOur partnersEarn money
Support
ChangelogTicketsupportInterruptionsSmokeping
Legal
TermsImprintPrivacy PolicySecurity
ZAP-Hosting Docs
All content is property of ZAP-Hosting GmbH & Co. KG