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

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