I wanted to ask if anyone has had any problems migrating a server with MySQL on it? I have a testbed linode that I just tried upgrading, and MySQL got b0rked pretty well. What are other people's experiences?

Moderator edit: split into a new thread to give it the attention it deserves; it was going to languish on page 2 of that other thread. For your own good, not because of a rule or anything!

_________________
You never know what you have until it's gone. And your backup is corrupted. And your boss tells you he needs it yesterday.

Check your socket location. I had a small issue with mysql using a socket located at /tmp and now using one in another directory.

I went ahead and upgraded my production server and had no problems. It turns out that I was having a slight problem with an upgrade to MySQL 5.1. Trying to use "do-dist-upgrade" from the command line didn't work (as noted in 9.10 docs), but performing the upgrade from "update manager" over an NX session worked like a charm.

_________________
You never know what you have until it's gone. And your backup is corrupted. And your boss tells you he needs it yesterday.