Nada Mysqlcheck didn't do a thing....
The table didn't have any columns after it ran.... Thanks Lachlan McIntosh -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Kuphal Sent: Sunday, 20 February 2005 9:37 AM To: Discussion about mythtv Subject: Re: [mythtv-users] Can't open file: 'jobqueue.MYI'. (errno: 145) Lachlan McIntosh wrote: >OK the fix is: > > >mysql mythconverg >drop table jobqueue; >CREATE TABLE jobqueue ( > id INTEGER NOT NULL AUTO_INCREMENT, > chanid INTEGER(10) NOT NULL, > starttime DATETIME NOT NULL, > inserttime DATETIME NOT NULL, > type INTEGER NOT NULL, > cmds INTEGER NOT NULL DEFAULT 0, > flags INTEGER NOT NULL DEFAULT 0, > status INTEGER NOT NULL DEFAULT 0, > statustime TIMESTAMP NOT NULL, > hostname VARCHAR(255) NOT NULL DEFAULT '', > args BLOB NOT NULL DEFAULT '', > comment VARCHAR(128) NOT NULL DEFAULT '', > PRIMARY KEY(id), > UNIQUE(chanid, starttime, type, inserttime) ); > > >Oh keep in mind that the table names are case sensitive (YAY) > > Actually, your fix was to run mysqlcheck or whatever the recovery program is for mysql. You can refer to their online documentation for how to repair damaged tables. Kevin _______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
