[wp-hackers] Using Live Database with Development environment

Chris Williams chris at clwill.com
Fri Mar 2 01:31:55 UTC 2012

I have a similar problem and was thinking of this exact solution.  Can you
provide any details on how to do that?  I'm not familiar with how to do
that in MySQL.


On 3/1/12 4:20 PM, "Daniel Grundel" <daniel at webpresencepartners.com> wrote:

>Connecting a development site to my production database would make me a
>little nervous. I'd be concerned that a plugin or something else on my dev
>site would bork up my production database.
>Have you considered setting up one way replication from your production db
>to a second development db? That would keep the dev site up to date
>possibly compromising your production data.
>Daniel J. Grundel
>Web Presence Partners
>772 678 0697
>On Mar 1, 2012 7:12 PM, "Dmitry Tokmakov" <dmitry at getmoxied.net> wrote:
>> Hello!
>> I have the following situation which I am trying to resolve and am
>> for some assistance with a strategy to do so.
>> I have:
>> 1. A production WordPress site that is being edited very frequently.
>> 2. A development WordPress site that needs to make use of the production
>> sites database.
>> I would like to setup the development server to make use of the same db
>> when edits are made to the prod or dev enviroment all data is in sync.
>> Does anyone have any other experience with this type of situation or
>> can recommend a strategy to go about doing this?
>> Thank you in advance,
>> Dmitry Tokmakov
>> Digital Spin
>> _______________________________________________
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
>> http://lists.automattic.com/mailman/listinfo/wp-hackers
>wp-hackers mailing list
>wp-hackers at lists.automattic.com

More information about the wp-hackers mailing list