Two Different Installs Same Data

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

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?