[wp-hackers] Using Live Database with Development environment

Daniel Fenn danielx386 at gmail.com
Fri Mar 2 01:37:38 UTC 2012

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

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.

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
>>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
> _______________________________________________
> 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