From: Matthias Kestenholz <mk@spinlock.ch>
To: Luciano Rocha <luciano@eurotux.com>
Cc: Ryan Taylor <ryan.taylor@leeds-art.ac.uk>, git@vger.kernel.org
Subject: Re: Mirroring mySQL using Git
Date: Tue, 06 May 2008 15:29:25 +0200 [thread overview]
Message-ID: <1210080565.7022.11.camel@futex> (raw)
In-Reply-To: <20080506132422.GA13125@bit.office.eurotux.com>
On Tue, 2008-05-06 at 14:24 +0100, Luciano Rocha wrote:
> On Tue, May 06, 2008 at 02:03:01PM +0100, Ryan Taylor wrote:
> > Hi,
> >
> > I'm wanting to mirror my mysql databases from my live web box to my dev
> > box. The database are updated by a CMS on the live box and I need to be
> > able to transfer these updates to the dev box.
> >
> > Is this possible with git?
>
> You'd be better off with asynchronous replication. See
> <http://dev.mysql.com/doc/refman/5.0/en/replication.html>.
>
> Note that you go the git route, or other file-based solution, you'll
> have to freeze operations to the filesystem where the DBs reside, or
> you'll corrupt the copy.
Alternatively, you can save a SQL dump without extended inserts and with
all comments stripped (especially the embedded timestamp).
Still, replication is a much better alternative (if possible).
--
http://spinlock.ch/blog/
prev parent reply other threads:[~2008-05-07 6:51 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
2008-05-06 13:03 Mirroring mySQL using Git Ryan Taylor
2008-05-06 13:24 ` Luciano Rocha
2008-05-06 13:29 ` Matthias Kestenholz [this message]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=1210080565.7022.11.camel@futex \
--to=mk@spinlock.ch \
--cc=git@vger.kernel.org \
--cc=luciano@eurotux.com \
--cc=ryan.taylor@leeds-art.ac.uk \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.