[mythtv-users] Problem Recording

[Michael J. Sherman]

Okay, you ought to have at least a working knowledge of Linux and MySQL. 
  But anyways, "drop database mythconverg" is a command that you run 
inside the mysql program.  At a shell prompt, run the command "mysql". 
You will then be at another prompt that will look like this: "mysql>". 
At that point type in "drop database mythconverg;" and hit enter. Then 
type in "quit" and hit enter.


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,
>>
>>
>>_____