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

Re: what to do about a database?

From: Andrew Thompson <subversionuser_at_aktzero.com>
Date: 2005-03-07 22:50:50 CET

Richard Rodger wrote:
>
> I would dump the database to CSV files - MYSQL can do this quite easily.
> Then you can version the CSV files, which are just text.

Could you point me towards how you're able to get CSV out of mysql? I
did a few mysqldump's this morning, but they were all formatted for
direct rebuild of the database.

> When you want to rebuild, just create an empty database and read it all
> in. PHP has a pretty good module for parsing CSV files, I believe.

I'll have to look into that. My web-able programming is currently
limited to php.

> Might not work so well for very large tables, and might conflict with
> automatically incremented primary keys, so ymmv.

The table I've got in place now has an auto increment key field, but I
don't really need it, so that should be solvable.

-- 
Andrew Thompson
http://aktzero.com/
Interested in hosted SVN repositories? Email me, let's talk...
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Mon Mar 7 22:53:14 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.