[wp-hackers] Using Live Database with Development environment
banago at gmail.com
Fri Mar 2 09:44:54 UTC 2012
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.
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
> 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
> > 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>
> >>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
> >>site would bork up my production database.
> >>Have you considered setting up one way replication from your production
> >>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
> >>> 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
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
More information about the wp-hackers