[mythtv-users] Problem Recording

[Kirby Vandivort]

you _do_ need to be in mysql at the time.

On Fri, Aug 22, 2003 at 10:43:14AM -0700, Colin Armstrong wrote:
> 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
> 

> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


-- 

Kirby Vandivort                      Theoretical and Computational Biophysics 
Email: kvandivo at ks.uiuc.edu          3051 Beckman Institute
http://www.ks.uiuc.edu/~kvandivo/    University of Illinois
Phone: (217) 244-5711                405 N. Mathews Ave
Fax  : (217) 244-6078                Urbana, IL  61801, USA