Moving servers within my host, how to move the databases? (3 posts)

  1. Dgold
    Posted 8 years ago #

    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?

  2. vkaryl
    Posted 8 years ago #

    Best tutorial: http://www.tamba2.org.uk/wordpress/backup/

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

  3. Dgold
    Posted 8 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic