Re: what to do about a database?

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