Web Hosting Talk







View Full Version : HELP! MySQL wont start!!!


raqman
03-16-2002, 06:19 AM
Hey guys, been consistently opening lots of mysql connections with my forum for a while on my ensim box (rackshack)
Today I got a permanent error whenever I tried to access mysql, too many connections. So I tried rebooting mysql. It stops it just fine, but does not finish starting it. It keeps giving me a 'failed' error. Can someone tell me how to find the error logs, or better yet, suggest a method of forcing SQL to start?

Thanks.

diederik
03-16-2002, 06:28 AM
does it just give a 'failed' error, or does it give some more info ?

And can u give me the url to the forum ?
Got experience with MySQL, but I'm no pro either, but I'll do my best ;)

cheesysticks
03-16-2002, 06:37 AM
This may not be your problem but :

You may want to search through your forums code and check if it is or is not using persistant connections. Normaly the difference is (mysql_connect or mysql_pconnect). I would recommend using non persistant connections for your forum.

priyadi
03-16-2002, 08:28 AM
Try starting mysqld manually, /usr/sbin/mysqld on most cases.

raqman
03-16-2002, 04:57 PM
MAunally starting it did not work.

raqman
03-16-2002, 06:25 PM
Like to add I think this is a mysql.sock error thats cuasing to remain crashed. Anyway I can clear the sock file, or do something to get sql to start?

Thanks.