Title: Migrate WP database ONLY
Last modified: August 20, 2016

---

# Migrate WP database ONLY

 *  Resolved [JimDiGritz](https://wordpress.org/support/users/jimdigritz/)
 * (@jimdigritz)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/migrate-wp-database-only/)
 * So, my host is decommissioning the MySQL server that my WP installation(s) are
   using.
 * I have about 10 WP sites on this database server.
 * Worried about manually cloning the db’s through PHPMyAdmin (eg screwing up) I
   went ahead and paid $197 for [Backup Buddy](http://pluginbuddy.com/purchase/backupbuddy/).
   It does backups, migrations etc.
 * Sadly after buying and installing BackupBuddy (which looks great BTW) I found
   out that my host (Namesco) won’t allow HTTP Loopback connections, which BackupBuddy
   needs to run the simulated cron jobs.
 * So two hundred bucks worse off and after a few weeks messing around with support
   teams for both BackupBuddy and Namesco I am now right back at the start, with
   the deadline for the DB decommissioning looming.
 * Can anyone explain in super simple steps how to copy my existing WP DB and import
   the data into a fresh new DB?
 * I have googled this to death but everyone seems to be dealing with migrating 
   to a new host or domain, which I am not.
 * Cheers
 * Jim

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

 *  [Sugar Apple](https://wordpress.org/support/users/blacklizt/)
 * (@blacklizt)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/migrate-wp-database-only/#post-2938377)
 * 10 wp in different database or 10 in one database ?
 * wow, pretty pricey for unused thing.
 *  Thread Starter [JimDiGritz](https://wordpress.org/support/users/jimdigritz/)
 * (@jimdigritz)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/migrate-wp-database-only/#post-2938379)
 * Hi SNSD News.
 * No I have 10 separate WP sites with their 10 separate databases all hosted on
   that database server eg mysql3.namesco.net – which is being decommissioned.
 *  [eridout](https://wordpress.org/support/users/eridout/)
 * (@eridout)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/migrate-wp-database-only/#post-2938382)
 * Have you considered whether perhaps you should be migrating to a new host?
 *  Thread Starter [JimDiGritz](https://wordpress.org/support/users/jimdigritz/)
 * (@jimdigritz)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/migrate-wp-database-only/#post-2938397)
 * Eridout.
 * Maybe, but at the moment I have a deadline to migrate these MySQL db’s. I may
   do a full review of my hosting plan/provider however that will just complicate
   things right now.
 *  Thread Starter [JimDiGritz](https://wordpress.org/support/users/jimdigritz/)
 * (@jimdigritz)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/migrate-wp-database-only/#post-2938464)
 * Okay, I have exported the database as a .sql file.
 * How do I import this into my new MySQL db instance?
 *  [fonglh](https://wordpress.org/support/users/fonglh/)
 * (@fonglh)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/migrate-wp-database-only/#post-2938472)
 * > I have googled this to death but everyone seems to be dealing with migrating
   > to a new host or domain, which I am not.
 * It doesn’t matter, it’s the same process.
 * There’s an Import tab in PHPMyAdmin which allows you to upload the sql file.
 *  Thread Starter [JimDiGritz](https://wordpress.org/support/users/jimdigritz/)
 * (@jimdigritz)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/migrate-wp-database-only/#post-2938474)
 * Okay, I have imported the .sql file into the new database instance.
 * It all looks good.
 * Now is it safe to just change the wp-config.php file with the new server details?
 * I’ve read some comments that editing this requires a re-install of WordPress…
 *  [fonglh](https://wordpress.org/support/users/fonglh/)
 * (@fonglh)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/migrate-wp-database-only/#post-2938478)
 * > Now is it safe to just change the wp-config.php file with the new server details?
 * Yes.
 * > I’ve read some comments that editing this requires a re-install of WordPress…
 * It will prompt you to do so if you haven’t imported the data correctly and are
   now pointing it to a blank database. But that means it sees an empty database
   and isn’t because you edited the config file.

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

The topic ‘Migrate WP database ONLY’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 8 replies
 * 4 participants
 * Last reply from: [fonglh](https://wordpress.org/support/users/fonglh/)
 * Last activity: [13 years, 10 months ago](https://wordpress.org/support/topic/migrate-wp-database-only/#post-2938478)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics