[mythtv-users] programgenres hosed...
gharris+list+mythtv at eklo.com
Tue Dec 26 21:14:47 UTC 2006
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:
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>
There are some other options in the linked page above, but those three
commands served my needs. Good luck!
On 12/24/06, Brian Guilfoos <mythtv at guilfoos.com> wrote:
> I had a kernel panic last night on my database server that must have
> occurred during an access to the programgenres - because the table is
> now marked as "in use" in phpMyAdmin, and a repair operation returns:
> mythconverg.programgenres repair error Incorrect file format
> When I try to run my (new, unfortunately) mysqldump script, I get:
> mysqldump: Got error: 130: Incorrect file format 'programgenres' when
> using LOCK TABLES
> It seems like my only recourse is to drop the table and recreate it, but
> I already know (from a previous problem) that mythtv won't gracefully
> handle missing tables. I can't find the current table design on the
> web. Could someone provide the table structure for me? Or does anyone
> have any other suggestions to fix/prevent this in the future?
> My current plan is to frequently dump the database so that if a
> corruption occurs again I can roll back to an old copy, at least until I
> fix the kernel panic issues.
> mythtv-users mailing list
> mythtv-users at mythtv.org
More information about the mythtv-users