[mythtv-users] 0.22 database upgrade woes

[Dale Pontius]

I tried to take the 0.22 plunge today.

I'm a Gentoo user, so I was well warned about the possibilities of full
or partial corruption.  Of course I hoped for the best, and was of
course disappointed.  I was flagged as having partial corruption.

So I followed all of the relevant instructions, dropped the database,
restored the provided blank database, then restored mine on top of it,
and of course backed it up.

Following this, I attempted 0.22 mythtv-setup.  It upgraded my database,
saving a backup first.  Then it launched into configuration, which I
expected, from the instructions.

When all is said and done, it has lost all of my recorded programs, my
old recorded programs, etc, etc.  It's as if I had started completely
from scratch.  Nor was there any warning that it was going to object to
the old content, or that it was throwing stuff away.  I've also taken a
dump of the new database, and verified that indeed all of the old
content is gone.

I was prepared for the worst, so right now I'm on my way back to 0.21,
hoping that there's something I can do to make this work right, next
time.  There is another Gentoo user who has made a script that attempts
to fix partial corruption, but it "knows" that it failed.  I'm giving
feedback to the author, in case it can be improved.

Google hasn't been my friend on this one, but if there are any other
suggestions, I'm listening.  I guess I can always give up and start
over, but I'd rather not.

Dale Pontius