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 _______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
