By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,604 Members | 858 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,604 IT Pros & Developers. It's quick & easy.

How to stop and start MySQL service automatically at certain time?

P: 21
I'm new to MySQL, and was hopping to find out how I can stop the service at 10am and start it at 2pm automatically in a batch file. Please let me know...
Thanks in advance!
Joe
Sep 25 '12 #1
Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,359
That depends on your OS. On Windows, you can create a scheduled task. I'm sure linux, unix, and mac osx has similar functionality in their OS.
Sep 25 '12 #2

P: 21
Hi Rabbit,

Thanks for your quick response. MySQL db is running with Windows 7. how can I stop the service at 9:00 am then bring it back on at 12:00pm. I'd like this to happen on a daily bases. I guess creating a batch file would be the ideal way to go, but please correct me if I'm wrong.
Thanks again!
Joe
Sep 25 '12 #3

Rabbit
Expert Mod 10K+
P: 12,359
You certainly could use a batch file. Just use the task scheduler to run it at the times you want.
Sep 25 '12 #4

P: 21
Thanks so much Rabbit..! That worked out well as far as setting up the task scheduler...
Sep 25 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.