You decide which services we may enable for analytics, personalization, and external content.
We use cookies and similar technologies on our website to personalize content, embed external media, and better understand how individual areas are used.
Necessary cookies
These entries support essential functions such as security, stability, and form processing.
Optional sections
AnalyticsMarketingPersonalizationExternal media
Your data may be processed with your consent or on the basis of legitimate interests. In the cookie settings, you can reject or explicitly allow each optional category.
Some services process personal data in third countries. By consenting, you also agree to this transfer. You can find more information in our Privacy Policy.
You can reopen and change your selection at any time. · 1.0.2
Learn how to properly import SQL files so your FiveM resources work correctly with your database → Find out more now
10 November 20263 min read0 Views0 helpful
Introduction
Many resources for FiveM require a database to function properly. Therefore, it is important that you correctly import the SQL files provided with your resources into your database so that the resources can create entries in your database and work as expected.
Info
Not all resources require a database to function! When you download a resource, check the description or documentation to find out if you need to import an SQL file.
Often, one or more files with the .sql extension are included in the resource's download files. These need to be imported into the database.
FAQ
Frequently asked questions
Open the Databases section in the dashboard of your game server and import the .sql file provided with the resource into your existing database.
Not every resource requires a database. Check the resource’s description or documentation to see if an SQL import is necessary.
Open the .sql file with a text editor and remove any CREATE and USE database lines. Your FiveM game server already has its own database with a different name, so these lines would prevent the import.
The CREATE line tries to create a new database, which you don’t need. The USE line points to a database with a different name than your existing one. Both are unnecessary when using your existing database and must be removed.
Feedback
Was this article helpful?
Your feedback helps us prioritize and improve content.
0 of 0 Users found this article helpful.
Personal support
Need more help than the guide provides?
Our ZAP support team knows your product — briefly describe your issue and we'll help you personally.
Navigation
FiveM
Preparing the SQL File
In this example, we import the SQL file for ESX. You should prepare the SQL file for the resource you want to import it for. To do this, open the folder of your resource that requires a database and look for a file with the .sql extension.
Info
Before proceeding with the import, open the .sql file with any text editor and check if the following lines are present:
If these lines are present in your .sql file, be sure to remove the CREATE and USE database lines and save the file, otherwise the SQL file cannot be imported.
The reason: The first line specifies that a new database should be created, which you do not need since your FiveM game server already has a database with a different name. The second line specifies that the database named essentialmode should be used, which is also unnecessary because you are importing into an existing database.
Importing the SQL File into Your Database
Now you should open the Databases section in the dashboard of your game server.
On the database page, you will find various functions for managing your database, including options for backup, creation, management, and more. Here, we focus on accessing your database. For more information, feel free to check out our other database guides: External Database Access.
Click the blue redirect icon that takes you to the phpMyAdmin tool, where you can easily manage your database. Log in with the credentials shown on the database page if prompted.
On the page, select your database from the list on the left. The name of your database always starts with the prefix zap.
If you have not used the database yet, it will currently be empty. Now you can finally import the .sql file.
Click the Import button in the top navigation bar of phpMyAdmin to open the import menu.
Then click the Browse... button, which opens a file explorer. Select the .sql file you want to import.
Info
The maximum file size is 2MB. If your SQL file is larger, you should use an SQL splitter to divide the large file into smaller parts. We recommend the tool Pinetools SQL-Splitter, which can help you with this. Afterwards, you can import the SQL files normally.
Finally, press the Import button at the bottom of the page to start the import. If everything worked, you will receive a success message and a new table will be created in your database, visible on the left.
Conclusion
Importing an SQL file for your FiveM game server is necessary to use many resources smoothly. If you have further questions or need help, our support team is available daily! 🙂
Server hosting from €2.49 / month, online instantly, DDoS protection included.
Preferred source on Google
