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