Link to home
Start Free TrialLog in
Avatar of jbalanski
jbalanski

asked on

Email notification when record added

Hi does anyone no how to get email notification when a record is added.

I have a application that pushes data to mysql, I would like to be notified when a record is added. I am thinking of a shell script, or a php script that we can run every 30 minutes.

Or the other way would be to check the database and if unit id doesn't have todays date as a record it would email us.

We are running mysql 4 on OpenBSD 3.8
ASKER CERTIFIED SOLUTION
Avatar of snoyes_jw
snoyes_jw
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jbalanski
jbalanski

ASKER

The application is not written by us and doesn't have that capability. Its on a windows box, it grabs data and pushes it to the mysql box.

if we don't get data from a particular device then we would like to know........i will look into the binary log and see what we have there
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial