Title: Moving SQL databases
Last modified: August 19, 2016

---

# Moving SQL databases

 *  [justinstrack](https://wordpress.org/support/users/justinstrack/)
 * (@justinstrack)
 * [17 years, 5 months ago](https://wordpress.org/support/topic/moving-sql-databases/)
 * 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](https://wordpress.org/support/users/figaro/)
 * (@figaro)
 * [17 years, 5 months ago](https://wordpress.org/support/topic/moving-sql-databases/#post-935389)
 * > 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](https://wordpress.org/support/users/dressedinvalue/)
 * (@dressedinvalue)
 * [17 years, 5 months ago](https://wordpress.org/support/topic/moving-sql-databases/#post-935407)
 * 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](http://codex.wordpress.org/Editing_wp-config.php)
   file with the new database name and password.
 *  Thread Starter [justinstrack](https://wordpress.org/support/users/justinstrack/)
 * (@justinstrack)
 * [17 years, 5 months ago](https://wordpress.org/support/topic/moving-sql-databases/#post-935414)
 * 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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 3 participants
 * Last reply from: [justinstrack](https://wordpress.org/support/users/justinstrack/)
 * Last activity: [17 years, 5 months ago](https://wordpress.org/support/topic/moving-sql-databases/#post-935414)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics