[mythtv] Can't use MythTV after svn Help

Bruce Markey bjm at lvcm.com
Sat Nov 5 20:30:20 EST 2005


Isaac Richards wrote:
> On Saturday 05 November 2005 06:14 pm, Bruce Markey wrote:
>> Steve & Laurie Sanders wrote:
>>> George,
>>>
>>> Sorry i guess i am a bit mysql illiterate. I have not a clue what to do
>>> with this, or how I could repair my database with it, or even if my
>>> database is even damaged to start with. mysql is greek to me and I don't
>>> understand how mythtv uses it. I would like to learn if I could find
>>> someplace to start.
>> Run the command:
>>
>> $ mysql -u mythtv -pmythtv mythconverg
>>
>> mysql> UPDATE recorded SET basename = CONCAT(chanid, '_',
>>     -> DATE_FORMAT(starttime, '%Y%m%d%H%i00'), '_',
>>     -> DATE_FORMAT(endtime, '%Y%m%d%H%i00'), '.nuv')
>>     -> WHERE basename = '';
>>
>> Cut'n'paste the parts after the "> " of the "mysql> " prompt.
> 
> Should we just do this at every backend start?

I don't know if that is really necessary. If there is a impromptu
vote, I'll say 'no' ;-).

--  bjm


More information about the mythtv-dev mailing list