Title: Two Different Installs Same Data
Last modified: August 20, 2016

---

# Two Different Installs Same Data

 *  [booblla](https://wordpress.org/support/users/booblla/)
 * (@booblla)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/two-different-installs-same-data/)
 * I tried searching for this but I can’t find anything because I’m most likely 
   phrasing it wrong.
 * I have two different WP installs but I need them to share the same database/dataset.
   I need the two installs to share the same post and user data.
 * I did this a few years ago but I can’t remember for the life of me how to do 
   it again or where to find the Howto.
 * If someone could point me in the right direction that would be great.

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

 *  [NateJacobs](https://wordpress.org/support/users/natejacobs/)
 * (@natejacobs)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/two-different-installs-same-data/#post-2337605)
 * In your wp-config file just set the database connection details to be the same.
 *  Thread Starter [booblla](https://wordpress.org/support/users/booblla/)
 * (@booblla)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/two-different-installs-same-data/#post-2337691)
 * Both sites are using the same DB, I just want the second install to read/share
   selected tables in the DB.
 * I found exactly what I want to do, but it doesn’t appear to apply to WP v3.
 * Original post: [http://wordpress.org/support/topic/two-sites-two-themes-one-database-same-content?replies=19](http://wordpress.org/support/topic/two-sites-two-themes-one-database-same-content?replies=19)
 * >  I’ve done this before, having 6 websites shoot out content from the same database.
   > It’s easy enough to do. Upload WP into both directories. Make sure they have
   > the identical wp-config.php file.
   > In the second sites directory do the following:
   >  In the wp-settings.php file
   > change the options database value to something like this:
   > // Table names
   >  $wpdb->posts = $table_prefix . ‘posts’; $wpdb->users = $table_prefix.‘
   > users’; $wpdb->categories = $table_prefix . ‘categories’; $wpdb->post2cat =
   > $table_prefix . ‘post2cat’; $wpdb->comments = $table_prefix . ‘comments’; $
   > wpdb->links = $table_prefix . ‘links’; $wpdb->linkcategories = $table_prefix.‘
   > linkcategories’; $wpdb->options = ‘YOURNEWPREFIX_options’; $wpdb->postmeta 
   > = $table_prefix . ‘postmeta’; $wpdb->usermeta = $table_prefix . ‘usermeta’;
   > $wpdb->prefix = $table_prefix;
   > See how I’ve removed $table_prefix . in the options line?
   >  Instead of YOURNEWPREFIX
   > put something like ‘site2’ or whatever you want.
   > Then, in PHPmyAdmin duplicate the wp_options table, and rename one of the them
   > to be YOURNEWPREFIX_options, so if you chose ‘site2’, it would be ‘site2_options’.
   > Bingo. Edit the information in the ‘site2_options’ table to refelct the correct
   > information for your second site and you will be on your way.
 * Anyone have any idea how to do this in WP v3?
 *  [JonathanTaphouse](https://wordpress.org/support/users/jonathantaphouse/)
 * (@jonathantaphouse)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/two-different-installs-same-data/#post-2337758)
 * There is no //Table names in wordpress v3 wp-settings.php file… does anyone know
   how we can do this now?
 * Thanks!!
 *  [aventura54](https://wordpress.org/support/users/aventura54/)
 * (@aventura54)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/two-different-installs-same-data/#post-2337759)
 * WordPress multisite would be the closest I can think. Have a look at it [here](http://codex.wordpress.org/Create_A_Network).
   
   Also as you already have installed wordpress this [article](http://codex.wordpress.org/Migrating_Multiple_Blogs_into_WordPress_3.0_Multisite)
   may be useful too.
 * Hope that helps
    Aventura
 *  [JonathanTaphouse](https://wordpress.org/support/users/jonathantaphouse/)
 * (@jonathantaphouse)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/two-different-installs-same-data/#post-2337760)
 * Will multisite help, as I want the content to be mostly the same on each?
 *  [aventura54](https://wordpress.org/support/users/aventura54/)
 * (@aventura54)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/two-different-installs-same-data/#post-2337761)
 * I couldn’t really tell you as personally, I have never tried it. Best thing to
   do would be to test it on localhost and see if you can post to two sites at once
   with same data I guess.
 * I suggested it because it integrates multiple wordpress “installs” so is most
   likely way to easily achieve what you are looking for.
 * Aventura

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

The topic ‘Two Different Installs Same Data’ is closed to new replies.

## Tags

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

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 6 replies
 * 4 participants
 * Last reply from: [aventura54](https://wordpress.org/support/users/aventura54/)
 * Last activity: [14 years, 4 months ago](https://wordpress.org/support/topic/two-different-installs-same-data/#post-2337761)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics