Posterous

Evan’s posterous

Adventures in pomodoro and other such things

Filed undermysql

See all posts on Posterous with this tag »

Evan Jehu


 
Evan Jehu's profile »

Tags

  • linux (20)
  • mac (7)
  • ssh (4)
  • yoga (4)
  • java (3)
  • maven (3)
  • cheat sheet (2)
  • mysql (2)
  • mythtv (2)
  • python (2)
  • View all 37 tags »
  • quote (2)
  • subversion (2)
  • template (2)
  • trac (2)
  • apache (1)
  • appengine (1)
  • apt-get (1)
  • backup (1)
  • bash (1)
  • blackberry (1)
  • cool app (1)
  • cron (1)
  • firefox (1)
  • flash (1)
  • humor (1)
  • img (1)
  • openssl (1)
  • pomodoro technique (1)
  • project (1)
  • regex (1)
  • rpm (1)
  • safari (1)
  • script (1)
  • usb (1)
  • video (1)
  • visualization (1)
  • web (1)
Subscribe to this posterous »
Unsubscribe »
Loading...
September 15, 2008

fix mythTv recording times after crash

  • Edit
  • Delete
  • Autopost

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  //

  • mysql
  • mythtv

Comments [0]

May 3, 2008

change user password on mysql

  • Edit
  • Delete
  • Autopost

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

Filed under  //

  • mysql

Comments [0]