Re: How to send queries to a database periodically
SQLyog (www.webyog.com) has an option called SQLyog Notification Services. It can execute a set of queries and even send you the report over email. Using this you can schedule it to run a set of queries anytime you want. Karam --- Peter PeterDresden <[EMAIL PROTECTED]> wrote: > 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. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to send queries to a database periodically
[snip] Where can I find cron for Windows? That will make my life a whole lot better! [/snip] It is called Task Scheduler http://www.iopus.com/guides/winscheduler.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to send queries to a database periodically
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 <[EMAIL PROTECTED]> wrote: > > - Original Message - > From: "Peter PeterDresden" <[EMAIL PROTECTED]> > To: > 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. > > Rhino > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 22/02/2005 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Power to people, Linux is here. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to send queries to a database periodically
[snip] 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. [/snip] Yes, you can do this via CRON, for example 0,5,10,15,20,25,30,35,40,45,50,55 * * * * mysql databasename < mySQLScript.sql or you can create a PHP file and run it from CRON 0,5,10,15,20,25,30,35,40,45,50,55 * * * * /usr/local/bin/php -q /path/to/my/php/script.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to send queries to a database periodically
- Original Message - From: "Peter PeterDresden" <[EMAIL PROTECTED]> To: 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. Rhino -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 22/02/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
