468,507 Members | 1,577 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,507 developers. It's quick & easy.

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

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
4 1767
Rabbit
12,513 Expert Mod 8TB
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
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
12,513 Expert Mod 8TB
You certainly could use a batch file. Just use the task scheduler to run it at the times you want.
Sep 25 '12 #4
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.

Similar topics

5 posts views Thread by Paul O. Morris | last post: by
4 posts views Thread by eladla | last post: by
reply views Thread by NPC403 | last post: by
3 posts views Thread by gieforce | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.