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

[Patrick Kirchner]

> From: mythtv-users-bounces at mythtv.org 
> [mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Kyle Rose
> Sent: Saturday, April 23, 2005 7:11 PM
> To: Discussion about mythtv
> Subject: Re: [mythtv-users] Recovering from "drop oldrecorded" ?
> 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'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',
> ) TYPE=MyISAM;
> For future reference, I got this by running mysqldump.
> Cheers,
> Kyle

Thanks Kyle,

That worked great.  Now I also see that the command was in my dump file. I
just had to add a "use mythconverg;" line to the top of the dump file before
I was able to restore it using "mysql -u root -p < mydump.file".

Thanks again,

Patrick.