Create your standalone fivem server database (SQL Importing)

Tutoriale, ghiduri de optimizare si suport pentru crearea serverelor.
Post Reply
User avatar
greenie
Full Member
Full Member
Posts: 2607
Joined: Sun Nov 21, 2021 4:55 pm
Jucator SA:MP ?: Nu
Nick:: greenie
Jucator CS ?: Da

Create your standalone fivem server database (SQL Importing)

Post by greenie »

What is a database?
A “database” is basically a file that saves data created by certain scripts or files being imported into your server that can later on be called importing all the data for a specific player or script allowing you to use anything you had prior again just from your database importing it back into the server for you to use. Once you disconnect from your server, everything you’ve done prior to joining the server will be updated in the database and stored to the recent information you had allowing you to lose no progress in your server whatsoever.

Now, every server comes with a pre-built database, however, it really depends on your hosting. Many servers have an option for you to have to create one manually instead of automatically. We aren’t doing manuals, we are going to set up an automatic database. If you’re wanting to set up your database manually, you’d have to purchase your hosting from a web host, such as Zap-Hosting, Rocket-Node, etc.

:question: Why do I need this for a standalone server?
Although your standalone server doesn’t use scripts that NEED a database, there are still scripts out there that need to be hooked to a database. For example, wanting to use gcphone for your server? You can do that, however, you need a database for it to work. There aren’t a lot of scripts that need a database, but there are some that require you having one!
:computer: Database Requirements:
Down below are some resources that I use to manage my own database, you don’t have to use them, however I find them easier to use than phpmyadmin.
Xampp download link → Here (Required for your database to run.)
HeidiSQL Download Link → Here (Makes importing .sql files easier.)
oxmysql Download Link → Here (Connects your server to the database.) (WILL NOT RUN WITH MYSQL-ASYNC)
mysql-async Download Link → Here (Connects your server to the database.) (WILL NOT RUN WITH OXMYSQL)
𝑴𝒂𝒚𝒃𝒆 𝒕𝒉𝒆 𝑬𝒂𝒓𝒕𝒉 𝒊𝒔 𝒕𝒉𝒆 𝑯𝒆𝒍𝒍 𝒐𝒇 𝑨𝒏𝒐𝒕𝒉𝒆𝒓 𝑷𝒍𝒂𝒏𝒆𝒕... ☢️

✅ GAZDUIRE JOCURI / VPS / GAZDUIRE WEB / SERVERE DEDICATE - Stock NELIMITAT / Valabil comandati pe https://www.zonek.ro/
Post Reply

Return to “Server Development”