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

Re: Subversion and mysql : version control for database tables and content

From: Les Mikesell <lesmikesell_at_gmail.com>
Date: 2007-08-30 19:35:05 CEST

Hugh Acland wrote:
> Hello,
>
> I am new to subversion. Is it possible to use subversion alongside a
> MySQL DB so that there is version control for every update to the DB -
> create new tables, edit rows etc. It would be very cool to be able to
> return a complete DB to the point it was at, say, 10:34:54 this morning
> without having to rely on hard-backups.
>
>
> Any chance this is possible?

If your database is small you could 'mysqldump' it at every state you
might want to recover and commit to svn (import the first copy, check it
back out, then dump on top of the working copy and commit). It wouldn't
catch every update and there would be a lot of overhead, but it might be
useful in some situations.

-- 
   Les Mikesell
    lesmikesell@gmail.com
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Thu Aug 30 19:29:43 2007

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