WordPress.org

1. cynthusia
   Member
   Posted 8 months ago #

   Hi there,
   I want to set up a testing environment - but NOT locally - I need to host it on a sub-domain so my clients can preview changes before I take any changes "live".

   so, the plan is:

   http://www.mysite.com = live site
   dev.mysite.com = development/testing site

   They need to use the SAME database tables.

   I have searched the forums and codex... i understand how to create 2 WP sites using the same database, but not the same tables within the database.

   i've read this:
   http://software.jonandnic.com/hack/wordpress-hacking-multiple-blogs-on-one-set-of-tables-2

   but it's for a previous WP version, and as my comment (at the very bottom) says, i can't even find the lines of code they are talking about in my "wp-settings.php"

   i've tried this plugin unsuccessfully:
   http://wp-hive.com/

   i've tried wordpress MU, but it didn't solve my problem:
   http://mu.wordpress.org/

   and of course i've read the codex instructions 23 times, but it doesn't solve my problem either:
   http://codex.wordpress.org/Installing_Multiple_Blogs

   please help! :) i hope it's a stupid oversight on my part and there is an (easy?) answer to this.

2. cratercraver
   Member
   Posted 3 months ago #

   I realize you probably found your answer months ago. That being said, I think the answer to your question is that when installing WP in dev.mysite.com, rather than make a new WP installation, you should simply copy the WP from your mysite.com installation.

   That way, the wp-config.php file will point to your existing database and tables, and WP should not create new tables.

   Note: because your blog and WP URLs will be new for the dev.mysite.com site, you should run wp-admin.php in the dev site and update those URL's wthin the General Settings form.

3. cratercraver
   Member
   Posted 3 months ago #

   I realize you probably found your answer months ago. That being said, I think the answer to your question is that when installing WP in dev.mysite.com, rather than make a new WP installation, you should simply copy the WP from your mysite.com installation.

   That way, the wp-config.php file will point to your existing database and tables, and WP should not create new tables.

   Note: because your blog and WP URLs will be new for the dev.mysite.com site, you should run wp-admin.php in the dev site and update those URL's wthin the General Settings form.

4. mrmist
   mooderator
   Posted 3 months ago #

   I feel compelled to point out that - should you get such a setup to work somehow - using the same tables for dev and live is very risky, as changes to dev could easily break your production site.

   Better by far to keep the two seperate, it's not like you need all your live content in dev.

Reply

You must log in to post.