Call a script(PHP, Perl) when MYSQL insert occurs

Question

What I'm looking is to execute a script as soon as there is an INSERT on one of the MYSQL table.

I wanted to export all the contents of the inserted row into formatted Excel file. (This will be done through external script written in PHP)

Main issue is to call the script as soon as the insert occurs.

First thing that occurred to me is to create a Trigger and call the script (Found that this is not best approach. Other thing occurred to me is running a crontab

Could anyone please suggest if there is a better solution for this?

PS: The INSERT happens through an external application and I have no control over it.

why not just have the script running the insert also write to the excel file? — CrayonViolent, Nov 15 '13 at 16:52
Hey Crayon, I'm using an external application which does the update and I have no control over it . (Sorry I did not mention that in my question) — Dhee, Nov 15 '13 at 16:54
Why don't you just have Excel connect directly to the database? — dave, Nov 15 '13 at 16:56

score 2 · Accepted Answer · edited May 23 '17 at 11:50

2

This question was answered here: Invoking a PHP script from a MySQL trigger btw.

Anyway, other possible solution is to create environment with replication (although there will be no slave), write your own mysql client connected to the master (simulating slave server) and waiting for commands comming through.

You can also create "tail -f" script listening on binlog file.

edited May 23 '17 at 11:50

Community

1
1

answered Nov 15 '13 at 16:56

Yarik Dot

1,063
1
7
12

Call a script(PHP, Perl) when MYSQL insert occurs

1 Answers1