periodically start and stop mysql

Hi,
I would like to periodically start and stop mysql on a schedule using
something like the Windows scheduler. Does anyone know a good way to
do this?

Thanks,
Bob

Re: periodically start and stop mysql

On Tue, 31 Oct 2006 06:55:35 -0800, Bob wrote:

> Hi,
> I would like to periodically start and stop mysql ...

/usr/share/mysql/mysql.server start

mysqladmin -u{usr} -p{pwd} shutdown

Your paths may differ. Also, there are other start/stop techniques that
you can find in the manual.

> on a schedule using
> something like the Windows scheduler. Does anyone know a good way to do
> this?

What system are you using?
The Linux crontab facility is perfect for this.

Windows scheduler? Yuck!
Don't see why not though.
Thomas Bartkus

Re: periodically start and stop mysql

Thanks! I don't understand what you mean by:
/usr/share/mysql/mysql.server start.

Thomas Bartkus wrote:
> On Tue, 31 Oct 2006 06:55:35 -0800, Bob wrote:
>
> > Hi,
> > I would like to periodically start and stop mysql ...
>
> /usr/share/mysql/mysql.server start
>
> mysqladmin -u{usr} -p{pwd} shutdown
>
> Your paths may differ. Also, there are other start/stop techniques that
> you can find in the manual.
>
> > on a schedule using
> > something like the Windows scheduler. Does anyone know a good way to do
> > this?
>
> What system are you using?
> The Linux crontab facility is perfect for this.
>
> Windows scheduler? Yuck!
> Don't see why not though.
> Thomas Bartkus

Re: periodically start and stop mysql

On Wed, 01 Nov 2006 11:37:55 -0800, Bob wrote:

> Thanks! I don't understand what you mean by:
> /usr/share/mysql/mysql.server start.

That is the path to a bash script that comes with a typical mysql
installation on Linux. "start" is an option with obvious meaning
available along with "stop", "restart", and "reload".

The script performs the specified function on the mysql server. With
lots of error checking and error recovery details.

I expect (but don't know!) that a similar (.bat or other executable)
script is available on a Windows installation. If it is, that would be
the obvious ticket for "start"ing or "stop"ing the mysql server from a
task scheduler.

-Thomas Bartkus

Re: periodically start and stop mysql

"Bob" wrote in message
news:1162306535.084854.300330@e64g2000cwd.googlegroups.com.. .
> Hi,
> I would like to periodically start and stop mysql on a schedule using
> something like the Windows scheduler. Does anyone know a good way to
> do this?
>
> Thanks,
> Bob
>

If you are on Windows and MySQL is running as a service, then try:

NET START MySQL

and

NET STOP MySQL

....put them in the task scheduler (MySQL is the service name, alter as
needed)...

Norm