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 =/ Link to comment https://forums.phpfreaks.com/topic/46563-solved-mysql-crash-and-restart/ Share on other sites More sharing options...
fenway Posted April 11, 2007 Share Posted April 11, 2007 Check the logs to see what happened. Link to comment https://forums.phpfreaks.com/topic/46563-solved-mysql-crash-and-restart/#findComment-226702 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.. Link to comment https://forums.phpfreaks.com/topic/46563-solved-mysql-crash-and-restart/#findComment-226775 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. Link to comment https://forums.phpfreaks.com/topic/46563-solved-mysql-crash-and-restart/#findComment-227084 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.. Link to comment https://forums.phpfreaks.com/topic/46563-solved-mysql-crash-and-restart/#findComment-228394 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. Link to comment https://forums.phpfreaks.com/topic/46563-solved-mysql-crash-and-restart/#findComment-228431 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. Link to comment https://forums.phpfreaks.com/topic/46563-solved-mysql-crash-and-restart/#findComment-228602 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 Link to comment https://forums.phpfreaks.com/topic/46563-solved-mysql-crash-and-restart/#findComment-228646 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. Link to comment https://forums.phpfreaks.com/topic/46563-solved-mysql-crash-and-restart/#findComment-228679 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 Link to comment https://forums.phpfreaks.com/topic/46563-solved-mysql-crash-and-restart/#findComment-228712 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 ^^ Link to comment https://forums.phpfreaks.com/topic/46563-solved-mysql-crash-and-restart/#findComment-228904 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.