[wp-hackers] Using Live Database with Development environment

[Baki Goxhaj]

This is a situation that many WP developers are coming across more and more
due to the fact that version control systems are being used very much, as
they should - they are a blessing. Now, when you need to test with the
actual site, just making a local copy of the live database won't always
work, especially on fast-chaining sites.

That bash script seemed promising  - looking into it more in-depth.

However, if somebody else has a personal approach to this, that would be
great if they share it with us.

Kindly,

Baki Goxhaj
www.wplancer.com | proverbhunter.com | www.banago.info<http://proverbhunter.com>


On Fri, Mar 2, 2012 at 2:37 AM, Daniel Fenn <danielx386 at gmail.com> wrote:

> 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
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>