SA-MP Forums Archive
MYSQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MYSQL (/showthread.php?tid=458466)



MYSQL - Alexis1999 - 16.08.2013

So I was basically thinking of starting using MYSQL instead of Y_Ini or similar INI file saving systems but I have some questions since I'm pretty unfamilliar with MYSQL.

Question A
When using MYSQL System is it easy to transfer the whole system to another database account ( For example you move into a new host and have a new mysql hosting ).

Question B
What exactly is the difference between SQL and MYSQL and where do the databases of SQL get saved at

Question C
Is there a place where I can temporary setup my MYSQL files for free without needing to buy a host until I finalize my gamemode

Well those were pretty much all my questions for now.

Thank you.


Re: MYSQL - Scenario - 16.08.2013

Yes, you can export an entire MySQL database by the click of a button; you can do the same for importing.

You're thinking of SQLite and MySQL- SQL is the type of language. Honestly, the main difference between the two depends on what you want. SQLite is fine for a SA:MP server, but many prefer MySQL- as do I.

You can put a MySQL server on your computer, actually. Just look into setting one up; you'll probably want phpMyAdmin as well!

Keep in mind that you shouldn't use MySQL on your SA:MP server unless you have knowledge of it. It's best to learn a bit about the SQL language before attempting to use it on a SA:MP server. You're simply going to do more harm than good- there's a lot more to it than people think.


Re: MYSQL - Alexis1999 - 17.08.2013

Quote:
Originally Posted by RealCop228
Посмотреть сообщение
Yes, you can export an entire MySQL database by the click of a button; you can do the same for importing.

You're thinking of SQLite and MySQL- SQL is the type of language. Honestly, the main difference between the two depends on what you want. SQLite is fine for a SA:MP server, but many prefer MySQL- as do I.

You can put a MySQL server on your computer, actually. Just look into setting one up; you'll probably want phpMyAdmin as well!

Keep in mind that you shouldn't use MySQL on your SA:MP server unless you have knowledge of it. It's best to learn a bit about the SQL language before attempting to use it on a SA:MP server. You're simply going to do more harm than good- there's a lot more to it than people think.
Hmm, I think I will go with MySQL as I would also like to create some UCP sometime and even though I learn as I go . That will just be another challenge to learn

Thanks for replying man.