SA-MP Forums Archive
MySQL - Loading a Database - 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 - Loading a Database (/showthread.php?tid=572437)



MySQL - Loading a Database - Ciarannn - 28.04.2015

I'm starting to learn MySQL and I've looked at a lot of tutorials. I think the best way to fully understand the language is to download a script with one and mess with it for a bit. So, I downloaded this script: https://sampforum.blast.hk/showthread.php?tid=22818.

Now, the problem is that the download files comes with a database.sql. He says this in the thread:

Quote:
Originally Posted by Moderntopia
Посмотреть сообщение
You also need a working MySQL server, which I expect you to have a basic understanding of already. The database.sql file contains the database structure, just execute the SQL queries in that file on your DB.
How do I do that?


Re: MySQL - Loading a Database - [KHK]Khalid - 28.04.2015

https://sampforum.blast.hk/showthread.php?tid=391920
https://sampforum.blast.hk/showthread.php?tid=38561


Re: MySQL - Loading a Database - Sithis - 28.04.2015

Some background: a database server is where you execute commands, such as inserting a new user account. The database server takes care of saving it on the harddisk somewhere. The .sql file basically contains instructions for your database server on how to create a structure for the stored data so that your gamemode can store the information correctly.