[mythtv-users] MySQL start up problem

[Paul Barker]

Jeremy Thompson wrote:

>
> Hello all,
>  Been breaking Linux for awhile now.  Followed Jarod's FC guide to the 
> letter.  Worked fine a few days ago.  I loaded the LIRC for my ATI All 
> in Wonder and it 'works'.  However, now the database won't start at all.
>
>  Here's some info I could think to provide:
>
> [quote]
> [root at mythtv mythtv]# /sbin/service mysqld status
> mysqld dead but subsys locked
> [/quote]
>
>  Start, restart, and stop all fail.  Just for grins I try to start 
> mythbackend below.
>
>
Hi

Check /var/log/mysqld.log for any errors. If there's nothing there I 
guess it could be a stale lock file. Make sure no mysql processes are 
running (ps -ef | grep mysqld) and if not look in /var/lock/subsys for a 
file called mysql which should be zero bytes long. Remove this file (rm 
/var/lock/subsys/mysqld) and try to start mysql again (service start 
mysqld).

If there are errors in the log file, post 'em up so we can see 'em ;-)

Hope this helps

Paul