[mythtv-users] Database Problems...
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.
More information about the mythtv-users