[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