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. -- 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: mysql@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. 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]
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
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: mysql@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. 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] 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
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]
