periodically start and stop mysql

[Bob]

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

[Thomas Bartkus]

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

[Bob]

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

[Thomas Bartkus]

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

[Norman Peelman]

"Bob" <bs********@yahoo.comwrote in message
news:11**********************@e64g2000cwd.googlegr oups.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