Printable View
I am curious if there is any way we can get the PT servers running atop MySQL instead of MSSQL.
I'd much rather prefer running the emulator under WinE and using MySQL instead of being forced to use MSSQL. I see a libmySQL.dll in the server package, even, but from what I have been reading, it only uses MSSQL - why is this dll in the package if it is not being used, then?!
Any follup on this is greatly appreciated.
I guess its very possible that it could be used, best way to find out would be to setup a server and test it, although I think the reason it may not be used is a higher functioning clan asset that MySQL can not support.
I doubt it would work out. MSSQL too tied into the server, plus who knows what stored procedures the game requires MSSQL to do that other SQL software can't do. I'm not ruling out that it's not possible, it's jsut that I don't see it happening.
I just thought of a reason, all of the clan scripts are written to work in MsSQL fashion, if you were to use MySQL you would have to re-write them all. But a server without clans or SoD should be able to run on MsSQL.
I dont understand much of MSSQL and I've done my server using the scripts that come along the files
But those accountdb database we create, it has a lot more than the script we insert there... aren't all those things needed?
If not, all you'd have to do is install MySQL and convert the mssql script files into mysql language
Not everything is "needed" but you may as well set them all up.
It's not worth it because you'll be disrupting the server just by editing it. The likeliness that you can convert the server over bug free is fairly slim. It would take a lot of time and effort; at which point would become a waste of time.
It's just not worth the time unless you were to get the basics done then make it an open project. I suppose it could be a log haul project, but if you're looking for quick results I would just stick with mssql =p
I agree with Wh005h... the project would not be worth it, time and stability related.
If your going to waste massive amounts of time on a project, I suggest finishing up the PTU project :juggle: I'll bet in the long run it would be more stable, much easier to configure, customize and bound to make a very popular server.