The best and most famous MySQL plugin for SA:MP out there!
This plugin allows you to use MySQL in PAWN. It's currently being developed by maddinat0r.
Move mysql.dll (Windows) or mysql.so (Linux) to your plugins/ directory. If you are on Windows you also have to move the libmysql.dll to your main server directory.
You'll have to edit the server configuration (server.cfg) as follows:
plugins mysql
plugins mysql.so
Q: I get a Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory) error, how do I fix this?
A: You don't have the MySQL client library installed. Install the "mysql-client" package.
Q: The plugin still can't find the "libmysqlclient_r.so.16", what can I do now?
A: If that error still occurs, you are probably using a newer version of the MySQL client library. In that case use the mysql_5.5.so, which is linked to the libmysqlclient18 rather than the libmysqlclient16.
Q: I get a Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16[...] error, is there any way to fix it?
A: That likely means that you are using a 64bit system and thus a 64bit libmysqlclient library. You'll have to use the static version of the plugin, the mysql_static.so.
Q: The plugin just fails to load on Windows, how can I fix this?
A: You have to install the Microsoft C++ redistributables (2010 (x86), 2010 SP1 (x86) and 2012 (x86)).
Q: I get a ton of debug messages regarding connections even though I'm calling mysql_connect only once, why is that so?
A: That's because the plugin uses multiple direct database connections per connection handle. The number of direct connections (and thus the number of those log messages) is 2+pool_size.
You'll need Microsoft Visual C++ and the boost libraries to compile the plugin. Open the project file, adjust the include and library paths (for the boost library), select Release at the top and compile the project solution.
You'll need g++-multilib, mysql-client and the boost libraries. Once you have all the required libraries, navigate to the project's folder and type make.
- AndreT (testing/several tutorials)
- DamianC (testing reports)
- JernejL (testing/suggestions)
- krisk (testing/suggestions)
- Kye (coding support)
- maddinat0r (developing the plugin as of R8)
- Mow (compiling/testing/hosting)
- nemesis (testing)
- Sergei (testing/suggestions/wiki documentation)
- xxmitsu (testing/compiling)