[mythtv-users] database gone south

ffrr ffrr at tpg.com.au
Sun Sep 25 02:20:50 UTC 2005


Greg Woods wrote:

>Something is strange with the database, at least, the part that controls
>the Guide and is populated by mythfilldatabase. Neither MythWeb nor
>mythfrontend can see any scheduling data beyond today. Everything else
>(at least, watch TV and watch recordings) works. If I run
>mythfilldatabase,  the output looks normal, including noting that there
>is already data for each day. But still no scheduling data.
>
>Anybody have a clue what might be wrong and how I would go about fixing
>it? The WAF was starting to go up pretty high until this happened. I did
>check, and while the system has multiple mysql.txt files on it, they are
>identical. I have tried running mythfilldatabase both as root and as the
>user I run mythfrontend as, but to no avail.
>
>--Greg
>
>  
>
Try to backup the data first with

mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql

You can check the database with
 
 mysqlcheck -u mythtv -pmythtv mythconverg

and can also repair it with

 mysqlcheck -r -u mythtv -pmythtv mythconverg


After which (might need to run mythfilldatabase again) you should have 
the guide back.


More information about the mythtv-users mailing list