* Mirroring mySQL using Git
@ 2008-05-06 13:03 Ryan Taylor
2008-05-06 13:24 ` Luciano Rocha
0 siblings, 1 reply; 3+ messages in thread
From: Ryan Taylor @ 2008-05-06 13:03 UTC (permalink / raw)
To: git
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?
And if so how?
Cheers
Ryan
^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: Mirroring mySQL using Git
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
0 siblings, 1 reply; 3+ messages in thread
From: Luciano Rocha @ 2008-05-06 13:24 UTC (permalink / raw)
To: Ryan Taylor; +Cc: git
[-- Attachment #1: Type: text/plain, Size: 690 bytes --]
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.
--
Luciano Rocha <luciano@eurotux.com>
Eurotux Informática, S.A. <http://www.eurotux.com/>
[-- Attachment #2: Type: application/pgp-signature, Size: 197 bytes --]
^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: Mirroring mySQL using Git
2008-05-06 13:24 ` Luciano Rocha
@ 2008-05-06 13:29 ` Matthias Kestenholz
0 siblings, 0 replies; 3+ messages in thread
From: Matthias Kestenholz @ 2008-05-06 13:29 UTC (permalink / raw)
To: Luciano Rocha; +Cc: Ryan Taylor, git
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/
^ permalink raw reply [flat|nested] 3+ messages in thread
end of thread, other threads:[~2008-05-07 6:51 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
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 is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).