[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