On Nov 5, 2005, at 3:36 PM, 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 dowith this, or how I could repair my database with it, or even if mydatabase is even damaged to start with. mysql is greek to me and I don'tunderstand 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?
Might save the devs long threads like this. Geoff
Isaac _______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
