A great help, although I resolved it already. But I'll save this. So ol' Greg R-A is a closet myther too? There's always more about Gregory.
On Mon, September 3, 2007 1:34 pm, Gregory K. Ruiz-Ade wrote: > Lan, > > just pulled this out of my (spankin' new) 0.20.2 install: > > mysql> describe recordedseek; > +-----------+------------------+------+-----+--------------------- > +-------+ > | Field | Type | Null | Key | Default | > Extra | > +-----------+------------------+------+-----+--------------------- > +-------+ > | chanid | int(10) unsigned | NO | PRI | 0 > | | > | starttime | datetime | NO | PRI | 0000-00-00 00:00:00 > | | > | mark | bigint(20) | NO | PRI | 0 > | | > | offset | varchar(32) | YES | | NULL > | | > | type | int(11) | NO | PRI | 0 > | | > +-----------+------------------+------+-----+--------------------- > +-------+ > 5 rows in set (0.00 sec) > > Hope that helps, > > Gregory > > On Sep 2, 2007, at 6:34 PM, Lan Barnes wrote: > >> Somehow either in upgrading to 0.20.2 or ... whatever ... I lost the >> recordseek table. >> >> Things seem to work but that can't be good. >> >> Is there a way to restore just one table in mythconverg, or should >> I make >> a dump, drop the data base, and recreate it? And if the latter, I'd >> appreciate a URL of the procedure, because my wiki searching sucks. >> >>> From my log. >> >> 2007-09-02 18:29:26.891 DB Error (delta position map insert): >> Query was: >> INSERT INTO recordedseek (chanid, starttime, mark, type, offset) >> VALUES ( >> '1043' , '2007-09-02T17:31:00' , '7016' , 6 , '2 >> 276712448' ); >> Driver error was [2/29]: >> QMYSQL3: Unable to execute query >> Database error was: >> File './mythconverg/recordedseek.MYD' not found (Errcode: 2) >> >> TIA, >> >> -- >> Lan Barnes >> >> SCM Analyst Linux Guy >> Tcl/Tk Enthusiast Biodiesel Brewer >> >> >> -- >> [email protected] >> http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list >> > > -- > Gregory K. Ruiz-Ade <[EMAIL PROTECTED]> > OpenPGP Key ID: EAF4844B keyserver: pgpkeys.mit.edu > > > > -- > [email protected] > http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list > -- Lan Barnes SCM Analyst Linux Guy Tcl/Tk Enthusiast Biodiesel Brewer -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
