[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.

Thanks!

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
>without
>possibly compromising your production data.
>
>Daniel J. Grundel
>Web Presence Partners
>webpresencepartners.com
>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
>>looking
>> 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
>>so
>> 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
>>maybe
>> 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
>http://lists.automattic.com/mailman/listinfo/wp-hackers



More information about the wp-hackers mailing list