periodically start and stop mysql

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Bob
    #1

    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

    Tags: None
    • Thomas Bartkus
      #2
      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


        Comment

        • Bob
          #3
          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

            Comment

            • Thomas Bartkus
              #4
              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





                Comment

                • Norman Peelman
                  #5
                  Re: periodically start and stop mysql

                  "Bob" <bshumsky06@yah oo.comwrote in message
                  news:1162306535 .084854.300330@ e64g2000cwd.goo glegroups.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


                    Comment

                    Previous template Next
                    Working...