[mythtv] an idea from ruby on rails

[Steve Daniels]

On 25/01/2008, Simon Kenyon <simon at koala.ie> wrote:
> i was thinking that with a small amount of effort myth could implement
> "downgrade the database" functionality in dbcheck.cpp.
> this would mainly be for people who are testing branches or who are
> trying to find a regression by bisection of svn versions.
>
> that is, for every db version, provide both upgrade and downgrade
> functionality. that way, you could move between versions without all the
> rigmarole (sp?) of messing around with mysql.
>
> of course, this comes with no code, so may be ignored :-)
> --
> simon

Hiya Simon, I'm intrigued as to what all the rigmarole is that you
have to go through to back up your DB? With no special shortcut
scripts in place (if there was it would be a single click/typed one
word command on the cli) I can back up my database with 7 mouse
clicks.. and I'm sure if my memory was better, I could just type out a
nice one liner to get it all done, but alas my memory is crap.

This sort of functionality would be nice, but I'm not too sure how
keen the dev's would be on having to write code to reverse their
database updates.. If at all possible, haven't looked at dbcheck.cpp
too closely recently, but what if a column/table had been dropped in
an update, because the info it contained was no longer needed in the
latest version, how would you then go about regenerating that content
when downgrading the database? Not sure if there are any cases like
that in MythTV though.

Steve Daniels