Azu Posted April 11, 2007 Share Posted April 11, 2007 Hi I'm using MySQL on windoz and when I got up this morning the MySQL service had crashed and I had to go into the service manager and start it again manually. Please tell me how I can make it so that it will automatically restart when it crashes! Whole website and server depend on the MySQL database =/ Quote Link to comment Share on other sites More sharing options...
fenway Posted April 11, 2007 Share Posted April 11, 2007 Check the logs to see what happened. Quote Link to comment Share on other sites More sharing options...
Azu Posted April 11, 2007 Author Share Posted April 11, 2007 I don't know what logs to check and it doesn't really matter to me what caused it. I just want to make sure that if it happens again it will restart itself. Please tell me how I can do this.. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 11, 2007 Share Posted April 11, 2007 If you don't care what caused it you won't be able to figure out what happened and it will happen again. Quote Link to comment Share on other sites More sharing options...
Azu Posted April 13, 2007 Author Share Posted April 13, 2007 I know that's why I just want to make it restart when it crashes please tell me how to do this okay? I'm sure it's something very simple that I am missing.. :s Surely it would be faster then finding the file that this error is logged in, shifting through all the logs in it to find the error, figuring out what it means, and fixing whatever the problem is, assuming it isn't just some random fluke in mysql's programming. So please just tell me how to make it automatically restart.. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 13, 2007 Share Posted April 13, 2007 Faster? Maybe, maybe not. Besides, there is no auto-restart, nor is there for any other system service. Quote Link to comment Share on other sites More sharing options...
gluck Posted April 13, 2007 Share Posted April 13, 2007 you need in investigate the issue. Now for auto restart you could use a scheduler like the same cron is used to check the service and start it if it is stopped. Quote Link to comment Share on other sites More sharing options...
Azu Posted April 13, 2007 Author Share Posted April 13, 2007 I have no idea how to investigate it though. I just no that every once in a while the process just turns off. That is all I know. I just want to either make it turn itself back on when this happens, or prevent this from happening, but I don't know how to sorry Quote Link to comment Share on other sites More sharing options...
gluck Posted April 13, 2007 Share Posted April 13, 2007 I have no idea how to investigate it though. I just no that every once in a while the process just turns off. That is all I know. I just want to either make it turn itself back on when this happens, or prevent this from happening, but I don't know how to sorry Use a task scheduler. Something like this: http://www.iopus.com/guides/winscheduler.htm check every 1 hour and see if the process is running. If not start it else quit. Quote Link to comment Share on other sites More sharing options...
Guest prozente Posted April 13, 2007 Share Posted April 13, 2007 If it is installed as a service then you can tell it to restart on failure. Control Panel > Admin Tools > Services > Properties of the service > Recovery tab Quote Link to comment Share on other sites More sharing options...
Azu Posted April 13, 2007 Author Share Posted April 13, 2007 Thanks, I tried that right before you posted it XD It hasn't crashed again yet so I'm not sure if it will work or not ^^ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.