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 correctly import SQL files into your RedM database to ensure resource functionality and database integration → Find out more now
10 November 20263 min read0 Views0 helpful
Importing SQL Files into Your RedM Database
Many resources for RedM 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 work! When you download a resource, check the description or documentation to find out if you need to import an SQL file.
In many cases, one or more files with the extension .sql are included in the resource download files. These must be imported into the database.
FAQ
Frequently asked questions
Open the Databases section in your game server’s web interface, click the redirect icon to phpMyAdmin, select your database (name always starts with the prefix zap), and import the .sql file using the Import button.
Yes, if it contains CREATE and USE database lines, you must remove these and save the file first—your server already has its own database with a different name, and these lines would prevent the import.
The maximum file size is 2 MB. Larger files must be split into smaller parts using an SQL splitter like Pinetools SQL-Splitter, then imported individually.
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
RedM
Preparing the SQL File
In this example, we import the SQL file for the RP framework RedEM. 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 extension .sql.
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 RedM game server already has a database with a different name. The second line specifies that the database named essentialmode should be used, which you also do not need since you are importing into an existing database.
Importing the SQL File into Your RedM Database
Now you should access the Databases section in your game server’s web interface.
On the database page, you will find various functions to manage your database, such as 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 to open the 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 file into smaller parts. We recommend the tool Pinetools SQL-Splitter, which does this for you. Afterward, you can import the SQL files normally.
Finally, click the Import button at the bottom of the page to start the import. If everything worked, you will see a success message and a new table will be created in your database, visible on the left.
You have successfully imported an SQL file into your game server’s database!
Conclusion
Importing an SQL file for your RedM 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
