Ok, so this would fix up my database to work with the current trunk?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bruce Markey
Sent: Saturday, November 05, 2005 3:14 PM
To: Development of mythtv
Subject: Re: [mythtv] Can't use MythTV after svn Help
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.
-- bjm
_______________________________________________
mythtv-dev mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
_______________________________________________
mythtv-dev mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
