Title: Multiple Sites, Same Database, Different Options Table
Last modified: August 19, 2016

---

# Multiple Sites, Same Database, Different Options Table

 *  Resolved [pvandervossen](https://wordpress.org/support/users/pvandervossen/)
 * (@pvandervossen)
 * [16 years, 6 months ago](https://wordpress.org/support/topic/multiple-sites-same-database-different-options-table/)
 * I’ve done extensive searching, and I’ve seen people with similar threads, but
   everywhere I see someone asking the exact same question as myself, I don’t see
   a response, so I figured I would try again.
 * I have an existing site. I want to split out some subsites that utilize the same
   content, users, etc. The purpose of the subsites is to display just one category
   of content. Essentially I am segregating content types for better user and advertiser
   targeting. The master site will still exist, and pulls all categories together.
 * Here is the kicker though, each of these subdomains will use the essentially 
   the same theme, but with different options. The different options are because
   the theme needs to display different categories of content. (Magazine style theme)
 * So I know I need subdomains, which I have setup. Each subdomain essentially contains
   the same information, theme files (which will be modified once I get this working)
   etc. The wp_config files all point back to the same database, because I want 
   to share content. And that all works, I essentially have cloned my site to the
   subdomain. However the issue is I need a customize the options for each site,
   so I need to utilize different options tables for each site.
 * I don’t see anyplace where this is possible. I found the table array in wp-db.
   php, and modified the name of the options table there (var $tables = array), 
   but when I do that, the site fails to install.
 * I’ve gone round and round with several plugins, and various ways of installing,
   but I can’t find anywhere which allows me to use a different options table. I’m
   by no means an expert, but I’m competent problem solver when it comes to working
   an issue like this. However I have apparently exhausted my capabilities at this
   point. Anyone have any experience, thoughts? Any help is greatly appreciated

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

 *  Thread Starter [pvandervossen](https://wordpress.org/support/users/pvandervossen/)
 * (@pvandervossen)
 * [16 years, 6 months ago](https://wordpress.org/support/topic/multiple-sites-same-database-different-options-table/#post-1217452)
 * Nevermind, I think I found it thanks top this site :
    [http://www.wiseontech.com/hack/wordpress-hacking-multiple-blogs-on-one-set-of-tables-2](http://www.wiseontech.com/hack/wordpress-hacking-multiple-blogs-on-one-set-of-tables-2)
 * Down in the comments they refer to more modern installs. I did this:
 * Edit the wp-db.php file in the wp-includes directory.
    In the function set_prefix(
   $prefix) section
 * After :
 * foreach ( $this->tables as $table )
    $this->$table = $this->prefix . $table;
 * Added :
    $this->options = ‘wp_’ . ‘options’;
 * Or whatever your new prefix is. Testing now, I’ll write again if I experience
   any issues. This is a case of spending 4 hours a few nights ago, and going around
   in circles. Then after only 20 minutes of trying tonight, getting it working.
   The benefits of rest apparently.
 *  [ri4u](https://wordpress.org/support/users/ri4u/)
 * (@ri4u)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/multiple-sites-same-database-different-options-table/#post-1217765)
 * How about images in the upload folder!! How will the one site refers to another
   for the graphics in the post.

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

The topic ‘Multiple Sites, Same Database, Different Options Table’ is closed to 
new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [ri4u](https://wordpress.org/support/users/ri4u/)
 * Last activity: [15 years, 9 months ago](https://wordpress.org/support/topic/multiple-sites-same-database-different-options-table/#post-1217765)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics