Saturday, December 6, 2008

Problem backing up myth database

> Before upgrading from mythtv 0.20 to 0.21, I tried backing up my
> database using:
> mysqldump -umythtv -pmythtv --extended-insert --databases mythconverg
> -c > backupfile
>
> However, I get the following error message:
> mysqldump: Got error: 145: Table './mythconverg/mythlog' is marked as
> crashed and should be repaired when using LOCK TABLES

From a mysql prompt, try "REPAIR TABLE mythlog", when using the mythconverg db of course.

No comments: