MySQLoo
- Download MySQLoo from GitHub here: https://github.com/FredyH/MySQLOO
- Select the fitting version for your enviroment, win32 for windows 32bit, linux for any linux 32bit ( win64 and linux64 mean 64bit )
Warning: 32bit/64 bit does not only mean the system, it also applies to the GMod server itself. That means if your GMod server is running in 32bit you will have to use the MySQLoo 32bit binary. By default all GMod servers are 32bit and you need to manually switch the branch to be able to run it in 64bit mode. You can read how to switch the branch here: https://developer.valvesoftware.com/wiki/SteamCMD#Downloading_an_app
- After you downloaded the right binary files, place them into the
garrysmod/lua/bin/folder on your server. If there is no bin folder in the lua folder, create one and place the binaries inside it.
Your folder structure should now look somewhat like this:
bin
garrysmod
->lua
-->bin
--->gmsv_mysql_<version>.dll
To update MySQLoo, simply download the new binary and replace the old one with it. For that your server should be turned off to not cause any issues. To verify you are using the latest version, youc console should say something like this: Your server is using the latest mysqloo9 version
MySQLoo is the API that MSync is using in order to be able to write into a database. Default GMod has no MySQL capabilities, only SQLlite ( local database file ) so we need to add these capabilities to it somehow. This is where MySQLoo comes into play, thanks to it we are able to connect to and execute SQL commands on a database server. Because of this MySQLoo is a hard dependency meaning MSync 2 is not able to work without it.