[mythtv-users] Recovering from "drop oldrecorded" ?

[Kyle Rose]

Patrick Kirchner wrote:
> Hello,
>  
> I was trying to restore my oldrecorded programs backup file into a fresh
> mythconverg database.  Things went horribly wrong, so I thought I'd
> start over on the oldrecorded tables and just dropped it using mysql.

Yeah, so, in general "delete from <table>" is a little nicer than "drop
table <table>". :)

Try this:

CREATE TABLE `oldrecorded` (
  `chanid` int(10) unsigned NOT NULL default '0',
  `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
  `endtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(128) NOT NULL default '',
  `subtitle` varchar(128) NOT NULL default '',
  `description` text NOT NULL,
  `category` varchar(64) NOT NULL default '',
  `seriesid` varchar(12) NOT NULL default '',
  `programid` varchar(20) NOT NULL default '',
  `findid` int(11) NOT NULL default '0',
  `recordid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`chanid`,`starttime`),
  KEY `endtime` (`endtime`),
  KEY `title` (`title`),
  KEY `seriesid` (`seriesid`),
  KEY `programid` (`programid`),
  KEY `recordid` (`recordid`),
  KEY `recordid_2` (`recordid`),
  KEY `recordid_3` (`recordid`)
) TYPE=MyISAM;

For future reference, I got this by running mysqldump.

Cheers,
Kyle