# Re: Tracking database changes. 2 messages from 2011-09-08 to 2011-09-08. Participants: Rodrigo Cortés, Victor Engmark. Thread: https://gitlist.dev/t/28336 ## Victor Engmark, 2011-09-08 12:12 Subject: Re: Tracking database changes. Message-ID: <20110908121225.GC32087@victor.terreactive.ch> URL: https://gitlist.dev/e/20110908121225.GC32087%40victor.terreactive.ch In-Reply-To: <30328581.178675.1315346163453.JavaMail.trustmail@mail1.terreactive.ch> ``` On Tue, Sep 06, 2011 at 06:55:56PM -0300, Rodrigo Cortés wrote: > Is there a way to use git to track database changes? 1. Export the data and/or data model with a tool like mysqldump. 2. Remove output which would clutter up your diffs without adding any useful information. This could include things like date and time of the export and user name of the exporter. 3. Commit and enjoy! Optionally create a cron job to export and commit automatically during off-peak hours. Cheers, Victor -- terreActive AG Kasinostrasse 30 CH-5001 Aarau Tel: +41 62 834 00 55 Fax: +41 62 823 93 56 www.terreactive.ch Wir sichern Ihren Erfolg - seit 15 Jahren ``` ## Rodrigo Cortés, 2011-09-08 12:16 Subject: Re: Tracking database changes. Message-ID: URL: https://gitlist.dev/e/CAFSYZ5T1fhej26KfT1TtGQ6%2BU4%3Dv1YxV1uTTD%3DpoYNeQW15w5g%40mail.gmail.com In-Reply-To: <20110908121225.GC32087@victor.terreactive.ch> ``` So... there is no "plugin" for git to do that work. On Thu, Sep 8, 2011 at 9:12 AM, Victor Engmark wrote: > On Tue, Sep 06, 2011 at 06:55:56PM -0300, Rodrigo Cortés wrote: >> Is there a way to use git to track database changes? > > 1. Export the data and/or data model with a tool like mysqldump. > 2. Remove output which would clutter up your diffs without adding any > useful information. This could include things like date and time of the > export and user name of the exporter. > 3. Commit and enjoy! > > Optionally create a cron job to export and commit automatically during > off-peak hours. > > Cheers, > Victor > > -- > terreActive AG > Kasinostrasse 30 > CH-5001 Aarau > Tel: +41 62 834 00 55 > Fax: +41 62 823 93 56 > www.terreactive.ch > > Wir sichern Ihren Erfolg - seit 15 Jahren > -- Rodrigo Cortés Carvajal Ingeniería Eléctrica Universidad Tecnológica de Chile ```