fix mythTv recording times after crash

Have you ever had mythTv crash on you and then show the length of recorded shows incorrectly? e.g. 37 hours for a CSI episode you know is only 1 hour long … running this on the console can fix it:

mysqlcheck -u mythtv -p --repair mythconverg recordedseek

Filed under  //

Comments [0]

change user password on mysql

mysql mysql
SELECT `Host`, `User`, `Password` FROM `user`;
set password for 'auser'@'%' = password('changeme');
flush privileges;

Filed under  //

Comments [0]