[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: Richard Rodger <richard_at_ricebridge.com>
Date: 2005-03-07 11:49:49 CET

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.

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.

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

richard

Andrew Thompson wrote:
> Greetings,
>
> I am trying to move all my documents into various repositories. On my
> website, which I am now attempting to maintain with svn, I use a couple
> of mysql databases to store pages.
>
> Does anyone have recommendations for keeping up with a database?
>
> I had the thought of using a script that would download individual
> records from a database into text files. I figured I could work out a
> php updater script to look for new "records" in a folder and add them to
> the online database after a rsync.
>
> Does that idea interest anyone?
>

-- 
Richard Rodger
Ricebridge Software
E: richard@ricebridge.com
W: www.ricebridge.com
T: +353 51 870635
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Mon Mar 7 11:54:39 2005

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