[wp-hackers] Using Live Database with Development environment

[Daniel Fenn]

That question is a little off topic but I can give some direction to
help you out (note that I have not done this myself) In the mysql
userguide (5.5 I'm talking about) There a whole chapter on setting up
replication.


The best idea is to just make a backup of the wordpress database, do
your testing on your test server then just make the changes on the
live server.

Regards,
Daniel Fenn







On Fri, Mar 2, 2012 at 12:31 PM, Chris Williams <chris at clwill.com> wrote:
> 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
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers