I found a thread that discusses how to make some minor hacks in order to share most of the same tables but not ALL of the same tables. Basically I would have each site use a unique options table and just share common tables like users, posts, meta data, categories, etc. This way they all have their own plugin tables, I don't have any issues with site name, etc. I tried doing it, but I'm thinking that the hive might need some special treatment. The thread is at:
http://software.jonandnic.com/hack/wordpress-hacking-multiple-blogs-on-one-set-of-tables-2
The top suggestions are for an older version, but if you look down they suggest modifying wp-db.php as follows:
Anyway, in Wordpress 2.5 you need to edit the wp-db.php file in the wp-includes directory. In the function set_prefix($prefix) section, you can override the settings. Following
foreach ( $this->tables as $table )
$this->$table = $this->prefix . $table;
the code should look like this:
$this->posts = ‘wp_’ . ‘posts’;
$this->users = ‘wp_’ . ‘users’;
$this->categories = ‘wp_’ . ‘categories’;
$this->post2cat = ‘wp_’ . ‘post2cat’;
$this->links = ‘wp_’ . ‘links’;
$this->postmeta = ‘wp_’ . ‘postmeta’;
$this->usermeta = ‘wp_’ . ‘usermeta’;
$this->terms = ‘wp_’ . ‘terms’;
$this->term_taxonomy = ‘wp_’ . ‘term_taxonomy’;
$this->term_relationships = ‘wp_’ . ‘term_relationships’;
Any idea how to get it to work when using your stuff?
- Scot
