Mysql 4.0.x and NPTL based systems.

After this MySQl error has started showing up...everything is screwed up. I am having unlimited problems with mysql ...which keeps on showing up one by one...even a 3 year old website whcih was running smoothly is now having errors. This is also without updating.

Anyways i would like to know how and what methods you guys have adopted and how you updated mysql without problems / downtime ? Also did you face any problems with scripts whcih uses mysql ?

I have over 300 websites running on the server and if i screw this then it will be one hell of a problem. So please suggest any possible way which can lower the risk.

first of all you may describe what are actually the problems you are experiencing after updating the mysql version. what mysql version you had. you updated to ? we aint no wizards here to guess what is your system made of

Not everything that is counted counts and not everything that counts can be counted