[mythtv-users] No current database version?

[Michael T. Dean]

On 02/20/2010 06:20 AM, Jongi wrote:
> On Sat, 2010-02-20 at 12:46 +0200, Jongi wrote:
>> $ mysqldump --host='192.168.1.102' --user='mythtv' --add-drop-table 
>> --add-locks --allow-keywords --complete-insert --extended-insert 
>> --lock-tables --no-create-db -p --quick 'mythconverg' >  
>> '/mnt/mythtv/media/mythconverg--20100219212721.sql'
>> Enter password:
>> mysqldump: Got error: 144: Table './mythconverg/settings' is marked 
>> as crashed and last (automatic?) repair failed when using LOCK TABLES
>>
> Did some google searching which led to do the below:
>
> $ /opt/mythtv-0-22/mythtv/contrib/maintenance/optimize_mythdb.pl

optimize_mythdb.pl is the proper solution for fixing crashed tables, but 
unfortunately it will not work with a crashed settings table because it 
won't be able to get the information it needs to fix the DB.

You'll need to use the mysql tools to fix it--I'm planning to put in an 
override to allow optimize_mythdb.pl to work, even with a broken 
settings table, but haven't written the code, yet.

Mike