Web Hosting Forum | Lunarpages

Author Topic: Mysql won't restart  (Read 6014 times)

Offline ws0x9

  • Newbie
  • *
  • Posts: 1
Mysql won't restart
« on: April 29, 2010, 06:26:44 AM »
I stopped the mysql process to change the "max_allowed_packet".  It seemed to successfully make the change but when I tried to restart the mysql service I get the following error:

ERROR!  MySQL manager or server PID file could not be found!

And the restart attempts but just hangs and does not restart.  

Any help would be appreciated and thank you in advance.

***UPDATE
Resolved through tech, didn't successfully update variable.
« Last Edit: April 29, 2010, 06:46:00 AM by ws0x9 »

Offline perestrelka

  • Master Jedi
  • *****
  • Posts: 1397
Re: Mysql won't restart
« Reply #1 on: May 10, 2010, 10:09:38 AM »
Hi Ws0x9,

Thanks for the update and sorry that nobody has replied you here earlier. It happens sometimes that configuration change prevents a service from starting up. That's why it is highly recommended backing up the configuration you are going to change before updating it. You can always revert it back then, if something stops working after the change is done to ensure the problem was indeed in it.
Kind Regards,
Vlad Artamonov

 

Share |