[mythtv] Can't use MythTV after svn Help

[Isaac Richards]

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?

Isaac