PRecompiled Binaries for Windows for use with MYSQL 5

[Coleshadowblades]

Ok here is the Binaries compiled for MYSQL5

http://acashyasrealm.no-ip.org:90/EQ...801-MYSQL5.zip

[Coleshadowblades]

ok dont download those seems i broke the quests Im working on a few crash issues and will have new binaries there shortly

[Gameross]

I guess the big question is why? Is there some real benefit?

[Coleshadowblades]

you mean aside from a very prodound increase in speed and stability over mysql4?

[gottasummer]

This is useful to some who use mysql 5.

I used it on my windows server before i switched everything back over to linux... which my eq server still is not at a point where i can get it to run stabily on linux

But... as I have said... MySQL 5 is another option, its the newer version of MySQL... I am not ready to upgrade, but if you have already done so, this will help you out.

[Gameross]

Originally Posted by Coleshadowblades

you mean aside from a very prodound increase in speed and stability over mysql4?

Are people having stability issues or even speed issues because of mysql4? Hadn't read anything about either issue.

In case ya can't tell, I come from the grass isn't always greener school of computers. Remember Windows ME!

Either case, you should be working with developers to impliment this change and not doing your own thing and splintering Emu developement. Just seems to make sense.

[Coleshadowblades]

Excuse me but I unlike MOST am sharing what I have learned with the devs if you paid attention to the changelog the upgrade to enable mysql 5 support IS done by one of the devs they however compile for MYSQL4 which means the default binaries DONT work with mysql 5. now let me put it to you in laymans terms mysql five executes queries far faster then 4 4 is about 2 years or so out of date. zones boot far faster and the emu loads astoundingly fast now. I am not splintering anything. Merely providing WORKING binaries for people who WANT to upgrade to mysql 5 because the devs wont/havent provide/ed them. So kindly refrain from throwing accusations at someone trying to actually be HELPFULL to the community unless you can substantially backup your accusations with something more then conjecture.

now I will be updating that download however it requires 3 changes to the database...

you need to :

As shown in latest build changelog
ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(8) UNSIGNED NOT
NULL DEFAULT '0'; 

needed edits found durring testing
ALTER TABLE accounts CHANGE `packencrypt` `packencrypt` BLOB NULL;
ALTER TABLE character_ CHANGE `extprofile` `extprofile` BLOB NULL;

(Which you should do ANYWAY when the field isnt being given a value anyway just as a coding standard)

~~~PLEASE NOTE!!!~~~ SPECIAL THANKS TO SESMAR For helping me get the binaries compiled!

I will also be putting the updated source files (Since the devs have yet to take unused file references out of the solution file) so people new to the emu and dont know that the files arent even used but present in the project can compile easily

[sesmar]

Originally Posted by Gameross

Either case, you should be working with developers to impliment this change and not doing your own thing and splintering Emu developement. Just seems to make sense.

The devs have released the newest version of the emu (0.7.0-801) to be compatable with MySql 5. However, after I downloaded the binaries and upgraded to MySql 5 (since I have been waiting for an offical release for this) I was getting client not compatable errors. Figuring this may have something to do with it the precompiled binaries having been compiled on a machine still using the MySql 4.0.x include and lib files I grabed the source and recomplied it, as it was, with the MySql 5 lib and include files. After doing this the server booted right up for me. Only problem was once I logged in and tried to cast a spell it would crash everytime.

So all I did was grab the 800 version source and made the few minor changes to the source (mostly changing the any reference to condition in sql statements to _condidtion) to make it compatable with MySql 5 as well. I recompiled the server booted it up logged in and it works great. I could not get the Zone to output debug information for some reason so I was unable to see what was causing the crashes. This is something I am working on now.