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
On Tue, May 06, 2008 at 02:03:01PM +0100, Ryan Taylor wrote:
Show 7 quoted lines
> 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/>
Matthias KestenholzRe: Mirroring mySQL using Git
On Tue, 2008-05-06 at 14:24 +0100, Luciano Rocha wrote:
Show 15 quoted lines
> 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/