[mythtv-users] No current database version?
Michael T. Dean
mtdean at thirdcontact.com
Sat Feb 20 18:46:20 UTC 2010
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' >
>> 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.
More information about the mythtv-users