{"thread":{"id":"13395","subject":"Mirroring mySQL using Git","startedAt":"2008-05-06T13:03:01Z","lastAt":"2008-05-06T13:29:25Z","messageCount":3,"participants":["Ryan Taylor","Luciano Rocha","Matthias Kestenholz"],"isPatch":false,"patchVersion":null,"patchTotal":null},"messages":[{"id":"76200","messageId":"4B58A837F454E14AA0453EDBADE96A62B5F2A2@mildred.leeds-art.ac.uk","threadId":"13395","inReplyTo":null,"subject":"Mirroring mySQL using Git","fromName":"Ryan Taylor","fromEmail":"ryan.taylor@leeds-art.ac.uk","sentAt":"2008-05-06T13:03:01Z","receivedAt":"2008-05-06T13:03:01Z","isPatch":false,"sender":{"key":"ryan.taylor@leeds-art.ac.uk","avatar":null},"body":"Hi,\n\nI'm wanting to mirror my mysql databases from my live web box to my dev\nbox. The database are updated by a CMS on the live box and I need to be\nable to transfer these updates to the dev box.\n\nIs this possible with git?\n\nAnd if so how?\n\nCheers\n\nRyan\n"},{"id":"76201","messageId":"20080506132422.GA13125@bit.office.eurotux.com","threadId":"13395","inReplyTo":"4B58A837F454E14AA0453EDBADE96A62B5F2A2@mildred.leeds-art.ac.uk","subject":"Re: Mirroring mySQL using Git","fromName":"Luciano Rocha","fromEmail":"luciano@eurotux.com","sentAt":"2008-05-06T13:24:22Z","receivedAt":"2008-05-06T13:24:22Z","isPatch":false,"sender":{"key":"luciano@eurotux.com","avatar":null},"body":"On Tue, May 06, 2008 at 02:03:01PM +0100, Ryan Taylor wrote:\n> Hi,\n> \n> I'm wanting to mirror my mysql databases from my live web box to my dev\n> box. The database are updated by a CMS on the live box and I need to be\n> able to transfer these updates to the dev box.\n> \n> Is this possible with git?\n\nYou'd be better off with asynchronous replication. See\n<http://dev.mysql.com/doc/refman/5.0/en/replication.html>.\n\nNote that you go the git route, or other file-based solution, you'll\nhave to freeze operations to the filesystem where the DBs reside, or\nyou'll corrupt the copy.\n\n-- \nLuciano Rocha <luciano@eurotux.com>\nEurotux Informática, S.A. <http://www.eurotux.com/>\n"},{"id":"76252","messageId":"1210080565.7022.11.camel@futex","threadId":"13395","inReplyTo":"20080506132422.GA13125@bit.office.eurotux.com","subject":"Re: Mirroring mySQL using Git","fromName":"Matthias Kestenholz","fromEmail":"mk@spinlock.ch","sentAt":"2008-05-06T13:29:25Z","receivedAt":"2008-05-06T13:29:25Z","isPatch":false,"sender":{"key":"matthias@spinlock.ch","avatar":"https://gravatar.com/avatar/bc18f396e70163d09ab458a341b1decb7e8b6ee3aa2c0c954ec20162e67c4d46?d=mp&s=160"},"body":"On Tue, 2008-05-06 at 14:24 +0100, Luciano Rocha wrote:\n> On Tue, May 06, 2008 at 02:03:01PM +0100, Ryan Taylor wrote:\n> > Hi,\n> > \n> > I'm wanting to mirror my mysql databases from my live web box to my dev\n> > box. The database are updated by a CMS on the live box and I need to be\n> > able to transfer these updates to the dev box.\n> > \n> > Is this possible with git?\n> \n> You'd be better off with asynchronous replication. See\n> <http://dev.mysql.com/doc/refman/5.0/en/replication.html>.\n> \n> Note that you go the git route, or other file-based solution, you'll\n> have to freeze operations to the filesystem where the DBs reside, or\n> you'll corrupt the copy.\n\nAlternatively, you can save a SQL dump without extended inserts and with\nall comments stripped (especially the embedded timestamp).\n\nStill, replication is a much better alternative (if possible).\n\n-- \nhttp://spinlock.ch/blog/\n"}]}