#FIVEM SQL files

1 messages · Page 1 of 1 (latest)

onyx sage
#

So I’m installing scripts right but some of them have sql files that are required for the script to work how do I run them

crimson spruceBOT
#

Hi there 👋
Thank you for creating a post on our Community Forum. Please keep in mind that we don't provide official support on Discord. This is a forum for the community, by the community. Meaning that help is not guaranteed. Now let's wait and see if someone of our lovely community can help you out!

newtip TIP: Need actual official support? Reach out to our customer care: zaplivechat
https://zap-hosting.com/en/customer/support/

quaint patio
#

what framework are you using ?

onyx sage
#

Like i can’t use ps-mdt because it has a SQL file that I can’t execute

quaint patio
#

with QB-Core you should’ve set up a database when setting up the FX-Server itself, did you do that ?

onyx sage
#

Ye

#

My server runs my scripts work

quaint patio
#

open up your database

onyx sage
#

But just not ones with sql

quaint patio
#

and then import your SQL file from there

onyx sage
#

What do I do ?

quaint patio
#

do you use XAMPP ?

#

for your database

onyx sage
#

Nah do I need to becuase my server is on zap hosting

#

I use xampp for my test server which is a home server and everything runs ok on there

quaint patio
#

i’m not sure, i’d set up XAMPP on zap too, as i had to when using a standalone server from Zap-Hosting and had to use databases there, use XAMPP on your main server now and your database should already be connected 🙂

onyx sage
#

How do I do that ?

#

Like set it up for zap

#

Oh never mind

#

I think I have got it

#

Wait so how would I execute the sql file like what software

#

@quaint patio

quaint patio
#

i’ll do it with you mate, so i ensure i don’t mess up your server and that i get everything correct 🙂

quaint patio
onyx sage
quaint patio
#

start

apache and MySQL

onyx sage
#

ok

quaint patio
#

then on MySQL press Admin

#

and then show me another screenshot if you can please 🙂

onyx sage
#

Yes

quaint patio
#

i hate database stuff, but its easy when you get used to it

onyx sage
#

It opens this

quaint patio
#

click on the QB core on your left hand side

onyx sage
#

It’s not the right qb-core files

#

Tho it’s my test server files

quaint patio
#

test it on your test server first

onyx sage
#

Ye it works I use hiedi sql

#

To run it

#

And then I will work

quaint patio
#

what database did you use to set up your main server

onyx sage
#

What do you mean 😭

quaint patio
#

so when you set up your server, did it ask you to put in a database name, password or anything like that ?

onyx sage
#

I can’t remember

#

Can I dm u instead of talking via this support thing

quaint patio
#

yeah course buddy 🙂