Moving SQL databases

  • justinstrack

    (@justinstrack)


    17 years, 5 months ago

    Okay my webhost recently left, without warning. I had my site backed up and am now on a new webhost.

    I had to reinstall wordpress I have mysql posts backed up but how do I re-insert them into WordPress using PHPMyadmin?

    Please provide step-by-step instructions.

    Note: When I reinstalled wordpress on my website, it made a database and I wanted to rename it or copy it to the new database.

Viewing 3 replies - 1 through 3 (of 3 total)
  • figaro

    (@figaro)

    17 years, 5 months ago

    I have mysql posts backed

    How did you backup your posts? Did you dump the database or export them through the WP admin?

    Ricky Irvine

    (@dressedinvalue)

    17 years, 5 months ago

    If you have a SQL database backup (as opposed to a WordPress export, as figaro was asking about) then you can use the Import feature in phpmyadmin. It’ll go something like this:

    1. Open phpmyadmin
    2. Choose the new WordPress database from the left column
    3. Choose Import along the top tabs
    4. Choose your SQL file and import it

    You’ll also need to edit your wp-config file with the new database name and password.

    Thread Starter justinstrack

    (@justinstrack)

    17 years, 5 months ago

    Resolved.

    What I did was, one, upload my backed-up mysql to my mysql on cpanel.

    2.I re-installed WordPress using Fantansico it created its own database.
    3. I just I downloaded my old mysql database I uploaded in step 1. I just uploaded it and downloaded it because that backup was on my laptop and I’m on my desktop.

    4. After downloading it I renamed my database to the one wordpress created during the install, to override it. There it was back up and running.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Moving SQL databases’ is closed to new replies.