Updating apache server live
Goto regedit in: HKEY_LOCAL_MACHINE/SYSTEM/Current Control Set/Service Find mysql and delete. This may seem obvious, but: Step 6 says to overwrite your existing My SQL install, but if you do, you'll overwrite any security changes you may have made to the mysql database (most probably the user and db tables).So only overwrite them if you know you haven't made any changes to that database.find all your old and files that were left over from previous installs and put them in you backup folder with the other ziped folders so the new install can't see them.8.place mysql 5's unzipped stuff where ever you want it to run from (mine is c:/mysql5.9.For instructions on how to perform a logical upgrade with a milestone release, see Logical Upgrade.
zip up all your old mysql (basedir and Data Dir) for backup and later use.7.
In simple terms there is no need to change your data folder and so you keep all the info and users data safe.
Updating the mysql_fix_privilege_tables is still the same problem for us though.
You do not need to uninstall the service Simply change the file in C:\windows\Then copy the new to the oldversion/bin/ folder.
Change the line basedir=C:/apache/mysql tobasedir=C:/apache/newversionfor example or whatever you called the new folder.