[mythtv-users] db upgrade ? please help :)

[Michael T. Dean]

On 09/21/2013 05:33 PM, Eric Sharkey wrote:
> On Sat, Sep 21, 2013 at 2:37 PM, fordy ydrof wrote:
>> Database error was:
>> Table './mythconverg/recordmatch' is marked as crashed and last (automatic?)
>> repair failed
> You need to fix this within mysql before doing anything with mythtv.
>
> I'd start with running:
>
> mysqlcheck --auto-repair mythconverg
>
> and then see how it goes after that.

Since it's impossible to back up a crashed database table, it's 
impossible to restore a database table that's crashed.  This means 
you're almost /definitely/ not restoring your database backup properly.  
It sounds like you're restoring it "on top of" a database schema (of 
some random schema version).

You should use the procedure described here to ensure everything is 
restored properly:

http://www.mythtv.org/wiki/Database_Backup_and_Restore#Replacing_an_existing_database

Either that, or you're restoring the database backup and then something 
is breaking it before you run mythtv-setup for the upgrade (i.e. you're 
running out of file system space, which is corrupting table data files, 
or your mysqld server is crashing or ...).

If you didn't restore the database like this, you should /really/ redo 
it properly, because if you restore on top of an existing database, 
things may seem to work fine, now, then break your next upgrade, and 
cause you to have to do a /lot/ of extra work to fix the corruption.  
Even if you have a weekend's worth of recordings in the new database, 
you'd be better off fixing the process to verify the schema is correct, 
then sticking the few recordings from this weekend into Video Library to 
watch.  (And if you use mythlink.pl to create a pretty view of your 
recordings before you replace the existing/unknown-state database, you 
can easily find the right files to move to Video Library and can give 
them good names.)

Mike