Re: Tracking database changes.

git.vger.kernel.org archive mirror
 help / color / mirror / Atom feed

* Re: Tracking database changes.
       [not found] <30328581.178675.1315346163453.JavaMail.trustmail@mail1.terreactive.ch>
@ 2011-09-08 12:12 ` Victor Engmark
  2011-09-08 12:16   ` Rodrigo Cortés
  0 siblings, 1 reply; 4+ messages in thread
From: Victor Engmark @ 2011-09-08 12:12 UTC (permalink / raw)
  To: Rodrigo Cortés; +Cc: git

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

^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: Tracking database changes.
  2011-09-08 12:12 ` Tracking database changes Victor Engmark
@ 2011-09-08 12:16   ` Rodrigo Cortés
  0 siblings, 0 replies; 4+ messages in thread
From: Rodrigo Cortés @ 2011-09-08 12:16 UTC (permalink / raw)
  To: Rodrigo Cortés, git

So... there is no "plugin" for git to do that work.

On Thu, Sep 8, 2011 at 9:12 AM, Victor Engmark
<victor.engmark@terreactive.ch> 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

^ permalink raw reply	[flat|nested] 4+ messages in thread

* Tracking database changes.
@ 2011-09-06 21:55 Rodrigo Cortés
  2011-09-06 22:18 ` Carlos Martín Nieto
  0 siblings, 1 reply; 4+ messages in thread
From: Rodrigo Cortés @ 2011-09-06 21:55 UTC (permalink / raw)
  To: git

Is there a way to use git to track database changes?

-- 
Rodrigo Cortés Carvajal
Ingeniería Eléctrica
Universidad Tecnológica de Chile

^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: Tracking database changes.
  2011-09-06 21:55 Rodrigo Cortés
@ 2011-09-06 22:18 ` Carlos Martín Nieto
  0 siblings, 0 replies; 4+ messages in thread
From: Carlos Martín Nieto @ 2011-09-06 22:18 UTC (permalink / raw)
  To: Rodrigo Cortés; +Cc: git

[-- Attachment #1: Type: text/plain, Size: 339 bytes --]

On Tue, 2011-09-06 at 18:55 -0300, Rodrigo Cortés wrote:
> Is there a way to use git to track database changes?

That question is too generic to receive a useful answer. You could do a
nightly dump of the database contents and commit that file. Whether that
will give you anything useful is a different matter.

Cheers,
   cmn


[-- Attachment #2: This is a digitally signed message part --]
[-- Type: application/pgp-signature, Size: 490 bytes --]

^ permalink raw reply	[flat|nested] 4+ messages in thread

end of thread, other threads:[~2011-09-08 12:42 UTC | newest]

Thread overview: 4+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
     [not found] <30328581.178675.1315346163453.JavaMail.trustmail@mail1.terreactive.ch>
2011-09-08 12:12 ` Tracking database changes Victor Engmark
2011-09-08 12:16   ` Rodrigo Cortés
2011-09-06 21:55 Rodrigo Cortés
2011-09-06 22:18 ` Carlos Martín Nieto

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).