[mythtv-users] How to create just one table in mythconverg
mrlinuxgroups at gmail.com
Mon Sep 3 02:01:20 UTC 2007
On 9/2/07, Lan Barnes <lan at falleagle.net> 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)
> Lan Barnes
don't know that I'd trust the rest of your system if things are
disappearing... but if you want
to re-create the recordseek table... this might do it.
DROP TABLE IF EXISTS `recordedseek`;
CREATE TABLE `recordedseek` (
`chanid` int(10) unsigned NOT NULL default '0',
`starttime` datetime NOT NULL default '0000-00-00 00:00:00',
`mark` bigint(20) NOT NULL default '0',
`offset` varchar(32) default NULL,
`type` int(11) NOT NULL default '0',
PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
this is created when you do a mysqldump of the database.
More information about the mythtv-users