razorcmw
29-05-2006, 10:39
I tried for ages to get TS and MYSql4 working and just couldn't. I read the forum posts about it, but I couldn't get them to work - and that might have been because I already had MySQL5 installed, and 4.025 didn't want to run along side it.........
Anyway - I have managed to get TS2 working with MySQL 5, and here's what I did.
FIrst off you need this file:
http://www.coldmetalwarriors.co.uk/downloads/dbexpmda.dll
This is a version of dbexpmysql.dll - but it workes with MySQL 5
You will also need to go to you MySQL\bin folder, and get hold of libMYSQL.dll.
Once you have both of these, place them into the folder where youe server-windows.exe is.
There will already be a libMYSQL.dll file in there - but it is for an older version of MYSQL so either ovewrite it or rename the original. Either way - make sure you are using the newer (larger) file from your MYSQL\bin folder.
Now you need to modify your server.ini file to add the following section - or mod the existing one:
[DBEXPRESS]
sqldir="C:\Program Files\Teamspeak2_RC2\mysql_sql\"
Drivername=mysql
Database=<you ts database in mysql>
Hostname=localhost
User_name=<db_username>
Password=<db_password>
GetDriverFunc=getSQLDriverMySQL
VendorLib=libmysql.dll
LibraryName=dbexpmda.dll
Active=1
Note the spelling of the getSQLDriverMySQL !!!! - also, note that I have explicitly set the full path to the sqldir variables. I found that if I didn't do this - TS couldn't find the files to interact with MYSQL. Make sure you at the training \
Replace the database name, username and password with the ones on your system.
Once this is done you should be ready to rock and roll. Start you TS server and once running - check you server.log file to make sure there are no errors.
If you want to migrate you existing SQLLITE data into MYSQL - you can use this little app
http://www.coldmetalwarriors.co.uk/downloads/tsDB_to_mysql.rar
I didn't write this - but I found it on the TS forum and it was very useful. Basically take your existing server.dbs file, place it in the folder where this script lives, and then run "run.bat". It will produce a .SQL file which will contain all the SQL code to create and populate your MYSQL DB with your existing data. I used MYSQL Admin to do a restore using this file.
Good luck
Razor.
Anyway - I have managed to get TS2 working with MySQL 5, and here's what I did.
FIrst off you need this file:
http://www.coldmetalwarriors.co.uk/downloads/dbexpmda.dll
This is a version of dbexpmysql.dll - but it workes with MySQL 5
You will also need to go to you MySQL\bin folder, and get hold of libMYSQL.dll.
Once you have both of these, place them into the folder where youe server-windows.exe is.
There will already be a libMYSQL.dll file in there - but it is for an older version of MYSQL so either ovewrite it or rename the original. Either way - make sure you are using the newer (larger) file from your MYSQL\bin folder.
Now you need to modify your server.ini file to add the following section - or mod the existing one:
[DBEXPRESS]
sqldir="C:\Program Files\Teamspeak2_RC2\mysql_sql\"
Drivername=mysql
Database=<you ts database in mysql>
Hostname=localhost
User_name=<db_username>
Password=<db_password>
GetDriverFunc=getSQLDriverMySQL
VendorLib=libmysql.dll
LibraryName=dbexpmda.dll
Active=1
Note the spelling of the getSQLDriverMySQL !!!! - also, note that I have explicitly set the full path to the sqldir variables. I found that if I didn't do this - TS couldn't find the files to interact with MYSQL. Make sure you at the training \
Replace the database name, username and password with the ones on your system.
Once this is done you should be ready to rock and roll. Start you TS server and once running - check you server.log file to make sure there are no errors.
If you want to migrate you existing SQLLITE data into MYSQL - you can use this little app
http://www.coldmetalwarriors.co.uk/downloads/tsDB_to_mysql.rar
I didn't write this - but I found it on the TS forum and it was very useful. Basically take your existing server.dbs file, place it in the folder where this script lives, and then run "run.bat". It will produce a .SQL file which will contain all the SQL code to create and populate your MYSQL DB with your existing data. I used MYSQL Admin to do a restore using this file.
Good luck
Razor.