Title: Multiple to single database
Last modified: August 18, 2016

---

# Multiple to single database

 *  Resolved [oriecat](https://wordpress.org/support/users/oriecat/)
 * (@oriecat)
 * [18 years, 10 months ago](https://wordpress.org/support/topic/multiple-to-single-database/)
 * I am looking to switch hosts, and the plan I am looking at only includes 1 database.
   Currently I have several. So I know I can do that using the table prefixes, but
   what I am wondering is how to transition everything over. Can I alter the table
   prefixes now by just changing them or will that screw something up, and is that
   even possible in phpmyadmin? If not, then how can I get my 2 separate blogs into
   one database without them getting mixed up?

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

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [18 years, 10 months ago](https://wordpress.org/support/topic/multiple-to-single-database/#post-593135)
 * If the $table_prefix is different in each database then you should have no problem,
   but assuming they are the same, couldn’t you do a backup with phpMyAdmin then
   do a search and replace and replace the old table prefix, with the new table 
   prefix.
 * Example replace all ‘wp_’ with ‘wpnew_’
 * Other idea, use the Export ability from blog 1, then install new blog 1 in the
   old database, with a different table prefix, Import the data, test everything,
   then just backup the database and restore into the combined database.
 *  [Trent Adams](https://wordpress.org/support/users/trent/)
 * (@trent)
 * [18 years, 10 months ago](https://wordpress.org/support/topic/multiple-to-single-database/#post-593137)
 * You can change all instances of your table prefix so that each has different 
   ones for sure. Then just change to that prefix and your new database info in 
   each respective config.php. I like the second solution though of making a new
   install for each blog with a different prefix and then importing the content 
   using the import/export function. Makes life the most simple.
 * Trent
 *  [ccoupe](https://wordpress.org/support/users/ccoupe/)
 * (@ccoupe)
 * [18 years, 10 months ago](https://wordpress.org/support/topic/multiple-to-single-database/#post-593142)
 * I would look for host that allows more databases. The above hints should work
   fine if you’re stuck with a lame host, If you thinking of moving, why move to
   a lame host? Often their Mysql is too old or their php is out of date. For certain
   their business practices are out of date. My 2 cents.
 *  Thread Starter [oriecat](https://wordpress.org/support/users/oriecat/)
 * (@oriecat)
 * [18 years, 10 months ago](https://wordpress.org/support/topic/multiple-to-single-database/#post-593194)
 * Thanks everyone! I will give it all a try.
 * ccoupe, I don’t think they are a lame host, I’ve used them before and had no 
   issues at all. The plan I am moving to is a pretty cheap limited time special.
   Everything else about it is good (for me), just the one database is the only 
   bad part, but since it is possible to live with it, I can deal with it and get
   a year of hosting free.

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

The topic ‘Multiple to single database’ 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/)
 * 4 replies
 * 4 participants
 * Last reply from: [oriecat](https://wordpress.org/support/users/oriecat/)
 * Last activity: [18 years, 10 months ago](https://wordpress.org/support/topic/multiple-to-single-database/#post-593194)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics