Portal Home > Knowledgebase > Articles Database > mysqld unable to start
mysqld unable to start
| Posted by hello_x, 08-23-2007, 07:27 AM |
| My server was having a high load so I stop httpd and mysqld. I tried to restart both service but only httpd is starting and mysqld failed. It keeps timing out.
service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
Please help. It was working and I only trying to restart it.
The load on my server now is 0 because the website is down.
Thanks for your help
-X
|
| Posted by dollar, 08-23-2007, 07:30 AM |
| check mysql.log (probably /var/log/mysql.log) and see if there's anything.
|
| Posted by Steve_Arm, 08-23-2007, 07:36 AM |
| In worst case restart server.
|
| Posted by FirmbIT, 08-23-2007, 07:57 AM |
| Do you have any current mysql processes running?
ps auxww | grep mysql
if so, kill them then try starting mysqld again.
|
| Posted by hello_x, 08-23-2007, 09:02 AM |
| No mysqld process is running.
This is the last 50 lines of /var/log/mysqld.log file.
|
| Posted by macker, 08-23-2007, 02:41 PM |
| Probable causes are either that your /etc/my.cnf changed (maybe got corrupted), or the files are no longer accessilbe (maybe got corrupted or deleted).
Look at /etc/my.cnf and see where it's storing the files, e.g. /var/lib/mysql/, then look in there for the files accounts.MYI, etc. Look for differences between the ownership, permissions, etc.
The error suggests the files aren't there, but if they are, it's probably a permissions issue.
|
| Posted by anatolijd, 08-23-2007, 08:27 PM |
| 070425 17:50:48 mysqld ended
this is irrelevant - last record from 2007-04-25.
Post your /etc/my.cnf here, there should be log file location specified.
if there is skip-innodb option - remove it and restart mysql.
Try commands,
# myisamchk /var/lib/mysql/*/*.MYI -o
# mysqlcheck -A -c
to check&repair tables
|
| Posted by kgs_namboothiri, 08-24-2007, 02:41 PM |
| check mysql.log (probably /var/log/mysql.log) and see if there's anything.
Also check .sock file exist or not usnderr mysql.
If some another mysql is running say LAMP then firt you should stop that mysql and start the mysql which you required.
default services under /etc/init.d/
kgs_namboothiri@yahoo.co.in
|
| Posted by david510, 08-24-2007, 11:32 PM |
| Try adding this line to the mysql conf /etc/my.cnf and restart mysql
skip-innodb
|
Add to Favourites 
Print this Article
Also Read
