WordPress.org

Ready to get started?Download WordPress

Forums

set up a testing environment - but NOT locally? and using the same DB *tables*? (4 posts)

  1. cynthusia
    Member
    Posted 5 years 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 4 years 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 4 years 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
    Forum Janitor
    Posted 4 years 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.

Topic Closed

This topic has been closed to new replies.

About this Topic