473,383 Members | 1,818 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

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 2057
Rabbit
12,516 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,516 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

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

Similar topics

5
by: Paul O. Morris | last post by:
Is there a script that I can run to stop a particular SQL server service on Win2003 server? I'm looking for a similar script to restart that service as well. Thanks.
7
by: shai | last post by:
I am working at .net 1.1, writing in c#. I have windows service with a COM object. Every unexpected time The COM object throw an error that make my service get stuck (do not respond). I can catch...
4
by: Jianwei Sun | last post by:
Hi, all, I have a question, and I hope to get some hints here.. I created a really simple service just to check why the service manager doesn't start my service the second time if the first...
4
by: eladla | last post by:
I have a windows service that I want to carry out an action on a certain day of the week at a certain time and if the time is missed for some reason, I want it to be carried out as soon as the...
1
by: peace2007 | last post by:
Hello, I've installed MySQL using "MySQL Server 5.0.27.exe" on a remote server machine on Windows 2003 server. But when I try to configure server instance using MySQL Server instance config...
4
blossam
by: blossam | last post by:
hi, i want to shutdown mysql service n after that i want to start it i m using mysqladmin -u root shutdown command to stop service now i want to start it using command do u know which command...
1
by: TechnoAtif | last post by:
Could not start the mysql service on localcomputer Error 1067:The process terminated unexpectedly. ------------------------------------------------------------------------------ Hi All. I 'm...
0
by: nethajireddy | last post by:
Hi, I want to start fax service, when i click "start" its showing..this error "The Fax service on "computer name" started and then stopped. Some services stop automatically if they have no...
8
by: Lemune | last post by:
Hi, I'm developing window service application on C# 2005. The service is to read a new excel file on certain directory, and process it to database. The service work find on XP. But when I...
6
by: santhanalakshmi | last post by:
Hi, I want to start the mysql services by manually in the dos on windows...... Starting an Mysql Service : shell>net start mysql The service name is...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.