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 makea 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
PGP.sig
Description: This is a digitally signed message part
-- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
