Hi David
Sybase and MS-SQL have a built-in stored procedure called xp_cmdshell
which lets you execute shell commands from within a stored procedure
or otherwise within the database process.
MySQL doesn't (I'm fairly sure) provide anything like that (although
I think someone had written a UDF in C that might do that). I don't
think that's really a problem with MySQL, on the contrary it's a good
thing because xp_cmdshell is potentially a big security issue, as any
shell program would be running as the same user who's running the
MySQL server.
It will probably work better if you put the triggering code in the
part of your application (like the PHP page, whatever) that changes
the data you want to be notified about, instead of in the database
itself.
Douglas Sims
[EMAIL PROTECTED]
On Sep 21, 2006, at 3:14 PM, Dave at Mysql wrote:
I am looking for a way to write a client program that will wake up
when
there is new data in the database, much like replication.
So instead of my client pulling the database on some fixed interval, I
would like the mysql daemon to push the data to my client when
there is
new data. I assume this is possible given that it is done with
replication. Does anybody have information on how to implement a
client
program like this?
I'm using PHP, but I'm not opposed to using C or C++ for this kind of
functionality.
Thanks.
David Godsey
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]