We are about to upgrade our MySQL boxes from 5.1 to 5.5 and because of the size, would prefer to do this as an in-place upgrade. Are there any issues with this? From my research, I noticed that the MySQL manuals for 5.0 and 5.1 mention that they are ok, but the 5.5 manual recommends a dump/restore. I've seen on blogs, for instance, vague responses of "I've had problems..." but nothing specific.
Has anyone done this and have had success or failure? For reference, I'm on RH 5. Thanks! -Dave
(Note: Not sure if this belongs here or DB Admins but I see more similar questions here )