I need advice. I don't know where to start. I have read the codex Moving WordPress and searched the Forum, even tried reading MySQL documentation. I still need help moving my 3 blogs to another server.
I wanted to upgrade WP2.0 to WP2.1, unfortunately my host said my old server was MySQL 3, and I need MySQL 4. But the same host offered me to switch for no charge to another server, that has MySQL 4. I moved all my files to the new server, except the databases ~ I don't know how to move databases. My host said,
"You should make a backup by mysqldump and convert it to 4.1 version and then import that to the new account."
How do I do that? I know how to get into PHPMyAdmin, but I don't know what to do there. How do I, ahem, take a mysqldump? Why is this not mentioned in the Codex? Should I be doing a different method -- such as export, import... or the Database Backup plugin way?