Portal Home > Knowledgebase > Articles Database > mysql server do not start
mysql server do not start
| Posted by OnlineServers, 04-27-2014, 12:49 AM |
| hi
my server mysql do not start ad give this alert:
root@server1 [~]# service mysql restart
MySQL server PID file could not be found! [FAILED]
Starting MySQL.The server quit without updating PID file (/var/lib/mysql/server1.mizbandp.com.pid). [FAILED]
server is cpanel
thanks firends
|
| Posted by Erawan Arif Nugroho, 04-27-2014, 02:59 AM |
| How about stop it and start it?
# service mysql stop
# service mysql start
And, how about mysql eror log?
|
| Posted by EthernetServers, 04-27-2014, 04:09 AM |
| Have you recently made any changes to /etc/my.cnf ?
Have you reviewed /var/lib/mysql/server1.mizbandp.com.err ?
|
| Posted by VectorVPS, 04-27-2014, 06:40 AM |
| Yup we're going to need to see the MySQL error log to help you. All the error message "THe server quit without updating PID file" means is that MySQL could not start because of an error, and that error will be found in the error log.
|
| Posted by TheCloudSimplified, 04-27-2014, 07:34 AM |
| Temporarily move your MySQL configuration file and restart the MySQL service to confirm whether a configuration error is causing the fault.
mv /etc/my.cnf /etc/my.cnf.bak; service mysql restart
Other points to check
- Verify the disk is read/write and not read only
- Check available disk space
- Check the contents of the .err logfile
|
| Posted by Srv24x7, 04-27-2014, 10:05 AM |
| Hi,
1. Check if any MySQL processes are running and if they are running, then kill those processes and then attempt starting the MySQL service.
2. Subsequently check the error logs while restarting the MySQL service.
3. Check the disk space, as this could be the cause of not writing to the file.
4. Check the my.cnf file to see for any inappropriate values in it that is causing MySQL to not load.
|
| Posted by OnlineServers, 04-27-2014, 12:54 PM |
| hi solved
problem was on innodb tables that we can to recovery it and premossion of mysql.sock on /tmp
thanks all
|
Add to Favourites 
Print this Article
Also Read
