[mythtv-users] Missing guide information

Michael T. Dean mtdean at thirdcontact.com
Wed Mar 11 18:26:25 UTC 2009

On 03/11/2009 11:15 AM, C.T. Paterson wrote:
> I eventually discovered that mysql was fretting about a table crash,
> and I had to drop the database and recover from a pre-crash dump of my
> DB.  Even then, I sort of had to hammer my DB into place.  Once the db
> was happy, though, the listings were able to be populated again.

You shouldn't have needed to drop/restore...  The optimize_mythdb.pl 
script (in contrib) as well as the repair button in MythWeb's database 
settings section are meant to fix corrupted MySQL tables.  (Note that 
they don't fix the data, so you'd need to re-run mythfilldatabase after, 


More information about the mythtv-users mailing list