On Saturday 05 November 2005 08:30 pm, Bruce Markey wrote: > 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' ;-).
Well, unless/until someone can figure out why the database update isn't working.. Isaac _______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
