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?
Every
> > application I've been involved with required some "seed" data. In your
> > scenario you either have to manage seed data separately from the schema,
or
> > 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.
Ed
---------------------------------------------------------------------
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