[mythtv-users] Problem Recording

[Colin Armstrong]

Sorry for this pathetic question but could you tell me the command to
run to the drop database command? when I type "drop database
mythconverg" it tells me that there is now command "drop" Sorry.
Thanks,
Colin
On Fri, 2003-08-22 at 10:17, Michael J. Sherman wrote:
> 1) When you dumped the DB did you also drop it?  You have to remove the 
> database with the sql command "drop database mythconverg".
> 
> 2) Don't run "mysql > mc.sql".  I think you just blanked out your mc.sql 
> file.  You want to direct the contents of the file into the mysql 
> command, so run "myslq < mc.sql".
> 
> 
> Colin Armstrong wrote:
> 
> > So, I did find the error on the mailing list and it did tell me what to
> > do, but now I am having trouble running the command. It told me to do a
> > database dump, which I did, and then to run mc.sql. After I did the
> > database dump, all of the files in mythconverg were still there and
> > mc.sql complained about there already being a database. Then, because of
> > this, I moved the bad file, recordmarkup.MYD to a different directory.
> > Then I ran "mysql > mc.sql" and it just sits there it does not give me
> > another terminal prompt but it goes done one line and the cursor just
> > blinks. It seems like it is doing something but I don't think it is,
> > because it has been going for 5 min and it has not stopped. One time I
> > stopped and checked to see if it had created recordmarkup.MYD and it had
> > not. Any ideas?
> > Thanks,
> > Colin
> > On Fri, 2003-08-22 at 07:18, Rob Minerick wrote:
> > 
> >>>DB Error (WriteRecordedToDB):
> >>>Query was:
> >>>INSERT INTO recorded
> >>>(chanid,starttime,endtime,title,subtitle,description,hostname,category)
> >>>VALUES(1004,"20030821160000","20030821163000","KRON 4 News at
> >>>4","","Sinkovitz, Liviakis.","conf-pc.ca.sandia.gov","News");
> >>>Driver error was [2/-1]:
> >>>QMYSQL3: Unable to execute query
> >>>Database error was:
> >>>Duplicate entry '1004-20030821160000' for key 1
> >>
> >>Colin,
> >>	You should probably try to search the mythTV archives @ 
> >>http://www.gossamer-threads.com/archive/MythTV_C2. Someone had an 
> >>identical (or very close) problem a few months back. Just search for 
> >>recordedmarkup.MYD in the user archives and I think you'll find your 
> >>answer.
> >>
> >>Cheers,
> 
> 
> ______________________________________________________________________
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users