Ive just bought a new site for my network, both are running on wordpress and both feeding similar content, is there any way i can make each site share certain tables in the wordpress database. Also if i wanted to run the sites off just a single wordpress installation would i be best off using wordpress mu or is there a more suitable plugin? thanks
You can log in to phpmyadmin and run a GRANT command like the one below. I say like the one below, because you're going to have to fill in the information with your relevant info. GRANT SELECT ON wordpress_database.wp_table TO wp_user@localhost; Code (markup): I'm not sure exactly how this would work for your situation, but I did this with WordPress and PHPBB so I could display forum posts on my blog. You'd probably need some additional code to make it work. You can find more information on GRANT at: http://dev.mysql.com/doc/refman/5.0/en/grant.html You could also use your rss feed on one site and feed it into the other. If you're running WordPress 2.5 I'd recommend using http://projects.radgeek.com/feedwordpress/ Or you could combine both databases into one database. Chris Coyier had to do this for two of his WordPress sites and wrote a tutorial to show you how: http://css-tricks.com/combine-all-the-posts-from-two-wordpress-blogs-into-one/