[wp-hackers] Using Live Database with Development environment

[Kokarn]

We're working on this as well.
Trying to build a development environment based on git that works with
multiple wordpress installations.

The problems we are facing right now is that some things we do in the
database data and some we do in the structure.
When we then try to push the changes we need to figure out a good way to
prioritize what changes to be made and stuff like that.

It's a challenge, to be sure :)

On 2 March 2012 11:55, Baki Goxhaj <banago at gmail.com> wrote:

> Andrew, do you do all the DROP/RESTOR/search/replacing manually? If no,
> we'd love it if you could share the code with us.
>
> Kindly,
>
> Baki Goxhaj
> www.wplancer.com | proverbhunter.com | www.banago.info<
> http://proverbhunter.com>
>
>
> On Fri, Mar 2, 2012 at 11:18 AM, Andrew Spratley <aspratley at gmail.com
> >wrote:
>
> > Personally I wouldn't feel comfortable running dev code against a live
> > DB directly.
> >
> > The way I'm thinking of automating it, is to take my nightly backups
> > and then restore them to a dev/staging database and run a variation of
> >
> http://interconnectit.com/124/search-and-replace-for-wordpress-databases/
> > to handle the domain renames for the dev URL.
> >
> > I use a switch statement around the DB config settings to pick the
> > correct DB depending on the HTTP_HOST variable.
> >
> > The simple flow would be:
> > DUMP (backup) live DB
> > DROP existing dev DB
> > RESTORE backup DB to dev DB
> > search and replace domain name on dev DB
> >
> > For most of my purposes a nightly view of the DB is more than enough
> > for development.
> >
> >
> >
> > On Fri, Mar 2, 2012 at 11:44 AM, Baki Goxhaj <banago at gmail.com> wrote:
> > > 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
> > >>
> > > _______________________________________________
> > > 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
>