[mythtv-users] Upgrading database from .18 to .19 then to .20

Stephen Atkins satkins at skircr.com
Wed Sep 13 11:19:48 EDT 2006

Michael T. Dean wrote:
> On 09/12/06 16:06, Stephen Atkins wrote:
>> Hello all.  Since .20 came out I thought I would give it a try.  But I
>> noticed that my .19 upgrade (back when it first came out months ago)
>> didn't upgrade everything in my DB.  Now since it has been months and
>> I've got a ton more data in there I'm wondering what will happen if I
>> try and move to .20.
>> What tipped me off was mysql complaining about a table with no columns
>> (oldrecordings).  I also noticed that the cutlist column in recorded was
>> still a tiny int not text.
>> Is there anyway I can get a script that will fix up my current .19 db so
>> its not even worse after moving to .20?

So I thought I would start with just backing up the the db as it is
right now.  Problem is that it hits the table oldprogram and dies with
an error of "can't open file".  All three (MYD, MYI and frm) are there.
 I guess my question now is what the heck do I do.


Stephen Atkins

More information about the mythtv-users mailing list