[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: versioning a [small] MySQL database with svn?

From: Ed MacDonald <edmacdonald_at_hotmail.com>
Date: 2005-02-27 19:45:40 CET

From: "Basile STARYNKEVITCH" <basile@starynkevitch.net>
Subject: Re: versioning a [small] MySQL database with svn?

> > Are you talking about dumping just the schema or the data as well?
> > application I've been involved with required some "seed" data. In your
> > scenario you either have to manage seed data separately from the schema,
> > end up checking in test/development data along with your schema thus
> > polluting your seed data.
> I dump the entire MySQL database. As I said before, this database is
> small. Currently, the mysqldump output size is a dozen kilobytes, and
> it won't grow past a megabyte or two (which is a manageable size);
> running the mysqldump command is very quick.

What I was getting at here is not about time or size but rather being able
to produce a "clean" system. Consider an order entry system. Through the
course of development and testing you would typically be creating orders.
When you deliver the system you want the order table *without* data and the
country/province table *with* data. If however your app uses data but
doesn't produce data (e.g a dictionary) then this might not be a concern.


To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Sun Feb 27 19:52:06 2005

This is an archived mail posted to the Subversion Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.