sv.db to MySQL Database

[cocomut]

So I'd like to run two darkrp servers that sync with each other, but I need to convert the sv.db over to the mysql database so that people don't loose their stats when I transfer to mysql. I've tried all the tools, tutorials, etc that I can find, none of them work anymore. Anybody got some new way I haven't found yet that works?

[Tomelyr]

[url]https://github.com/Svenskunganka/GDBC[/url]

[zerf]

Acecool made a tutorial for this
[url]https://dl.dropboxusercontent.com/u/26074909/tutoring/database/converting_sv_db_to_mysql.lua.html[/url]

[Acecool]

My tut only covers converting one table, the Set/GetPData table ( from the default helper-functions ). If there are other tables, then other techniques should be used. I may expand on that in the future to provide a full database dump like phpMyAdmin, but for now it just servers as an example as to what needs to be done to convert that table into something for MySQL..

Of course, you could convert it over as it is, but that storage method isn't the greatest design choice ( I would've at least had accounts table and then the <T> data could get inserted with an account id, column_name, and column_data instead of combining the unique-id with the column-name...