Re: How to send queries to a database periodically - Scott Hamm - com.mysql.lists.mysql

6 messages in com.mysql.lists.mysqlRe: How to send queries to a database...

From	Sent On	Attachments
Peter PeterDresden	24 Feb 2005 05:05
Rhino	24 Feb 2005 05:13
Jay Blanchard	24 Feb 2005 05:20
Scott Hamm	24 Feb 2005 05:24
Jay Blanchard	24 Feb 2005 05:29
Karam Chand	24 Feb 2005 05:48

Subject:	Re: How to send queries to a database periodically
From:	Scott Hamm (linu...@gmail.com)
Date:	02/24/2005 05:24:15 AM
List:	com.mysql.lists.mysql

Where can I find cron for Windows? That will make my life a whole lot better!

On Thu, 24 Feb 2005 08:14:13 -0500, Rhino <rhi...@sympatico.ca> wrote:

----- Original Message ----- From: "Peter PeterDresden" <pete...@hotmail.com> To: <mys...@lists.mysql.com> Sent: Thursday, February 24, 2005 8:05 AM Subject: How to send queries to a database periodically

Hi,

is there a possibillity in mysql to send periodically queries to a database, for example all 5 minutes? Or, a liitle bit off topic, is there a possibility to this via php? Or, is it normally possible to set up such a query via cron tab (unix based web servers only)? Thanx.

I use cron to do a daily backup of my MySQL databases; it runs a Bash script that does the work. You could just as easily write a Bash script that queries the database and runs every five minutes.

I don't know php but I expect that you could set up a batch php job - assuming php supports batch programs! - and run it whenever you want via cron. There are even versions of cron for Windows which could presumably do the same on Microsoft platforms.