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 _______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
