If you use MyISAM tables you could always do: SHOW TABLE STATUS LIKE 'tablename'
Then look at the Update_time column. If that has changed since last time then something has changed. Then implement a php/perl/whatever script around it to email you. Note: On my InnoDB tables this time seems to be quite often NULL, so I guess it's not implemented in InnoDB. Best regards, Richard Dale. Norgate Investor Services - Premium quality Stock, Futures and Foreign Exchange Data for markets in Australia, Asia, Canada, Europe, UK & USA - www.premiumdata.net -----Original Message----- From: Jayson [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 May 2005 23:59 To: mysql@lists.mysql.com Subject: email notification I'm looking for a feature in mysql where it will email me if ther are any changes in a particular database or table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
