Support » Installing WordPress » Moving servers within my host, how to move the databases?

  • 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?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Best tutorial:

    Once you get the backups, just import them into the new databases, THEN upgrade to 2.1.2.

    Thanks vkaryl.

    I’ve got 3 blogs (3 databases) to upgrade, and, I already uploaded (over-wrote) the WordPress files for 1 of the blogs. That was when I realized MySQL was only 3.23 not v4. But the Upgrade.php didn’t complete yet, it gave me the error message. *Hopefully* now I can import the backups like you showed me from that tutorial, and rescue all 3 of my blogs, even though they’re in different stages of upgrade right now.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Moving servers within my host, how to move the databases?’ is closed to new replies.