[mythtv-users] Mysqld won't start after system freeze

PAUL WILLIAMSON pwilliamson at mandtbank.com
Tue Mar 29 18:24:30 UTC 2005


>>> graham.dunn at leitch.com 03/29/05 9:04 AM >>>
On Tue, Mar 29, 2005 at 08:52:02AM -0500, PAUL WILLIAMSON wrote:
<snip>
> Look in /var/log/messages and /var/log/mysql/mysql.log (or
>/var/log/mysql.log - check my.cnf for location).
>
>That will help narrow down what's going wrong.
>
>Graham

I hate when I shoot myself in the foot.  I had been playing 
around with some of the setting in my.cnf to eek out some extra 
performance out of mysql, but had just upgraded myth to 0.17.
In the flurry of activity, I had never restarted mysql, thinking I'd 
get around to it. 

When the machine crashed last night, I took the opportunity to 
add a drive to my LVM array, and restarted.  I thought adding 
the drive might have had something to do with it, but it was a 
red herring.  Then again, I broke that rule to not add more than 
one piece at a time because of troubleshooting - I'd never know 
what the real problem was.

I forgot the most basic item - check the logs.  I had mistyped 
one of the setting in my.cnf, preventing mysql from starting.
Retyped it the right way and BAM! - mysql started right up.

I hate when that happens...

Thanks for all the help,
Paul





More information about the mythtv-users mailing list