Mirroring mySQL using Git

Mirroring mySQL using Git

[Ryan Taylor]

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

Re: Mirroring mySQL using Git

[Luciano Rocha]

[-- 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 --]

Re: Mirroring mySQL using Git

[Matthias Kestenholz]

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/