[mythtv-users] How to create just one table in mythconverg

[jack snodgrass]

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)
>
> TIA,
>
> --
> 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.

jack