[mythtv-users] programgenres hosed...
Brian Guilfoos
mythtv at guilfoos.com
Wed Dec 27 13:58:26 UTC 2006
Glenn Harris wrote:
> I just had a bunch of kernel panics over the weekend. In my case it
> seems to be hardware related .. but in the process of diagnosing that
> I ended up with quite a few blown up mysql tables. I found this in
> the MySQL reference manual:
> http://dev.mysql.com/doc/refman/5.0/en/repair.html
Handy link.
> Short summary:
> backup your data tables!
> (from a console)
> cd to the directory with your mythtv tables
> check for troubled tables with
> $ myisamchk *.MYI
> fix troubles tables with (quick repair)
> $ myisamchk -r -q <tablename>
> if that does not work, it should tell you what you need to do to fix
> them, in my case it was removing the 'quick' option
> $ myisamchk -r <tablename>
I had to do something a little more involved, as myisamchk claimed
programgenres was not a MyISAM table! For the benefit of others
searching the list archives, here is what I did (as root so I had
appropriate permissions). Edit paths and table names as needed.
shell$ cd /home/mysql/mythconverg
shell$ cp programgenres.MYI ~/mythtv/.
shell$ mysql -p mythconverg
mysql$ set autocommit = 1;
mysql$ truncate table programgenres;
mysql$ quit;
shell$ cp ~/mythtv/programgenres.MYI .
shell$ myisamchk -r programgenres
This dropped 1289 records, but fixed the table index. I can now see the
records, and operation is back to normal.
Thanks for your help, Glenn.
More information about the mythtv-users
mailing list