[mythtv-users] Database Problems...

Scott Milliken scott.milliken at e-comsultant.net
Fri Jul 20 20:23:04 UTC 2007


Robert Current wrote:
> My system stopped recording today...  Power outage last night.
> Anyway, I poked around, and it says no guide data available.  So I ran
> mythfilldatabase, and it can't insert into mythconverg because a table
> is marked crashed?
>
> Anyway, thought I'd try the handy script....
>
> debian-mythtv:/usr/src/mythtv/contrib# perl myth.rebuilddatabase.pl
> Can't locate Time/Format.pm in @INC (@INC contains: /etc/perl
> /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5
> /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8
> /usr/local/lib/site_perl .) at myth.rebuilddatabase.pl line 55.
> BEGIN failed--compilation aborted at myth.rebuilddatabase.pl line 55.
>
> There is no "Format.pm" in Time, but there is in Date... anyway, that
> script doesn't seem to work on Debian?
>
> Any ideas?
> _______________________________________________
>   
There's always the command:

mysqlcheck -r mythconverg

That will repair the database.  Optionally, you can specify a table name 
after the database name, such as programdata, like so:

mysqlcheck -r mythconverg programdata

Hope that helps.

Scott


More information about the mythtv-users mailing list