Re: MySql after inset trigger not exporting new inserted data into csv file

[Peter Brawley]

An After Insert Trigger fires before Commit, and the PHP sys_exec() call executes after the PHP script finishes---that has to be so, otherwise multi-operation transactions, rollbacks &c would be impossible. So usually it's a bad idea to invoke an external process from a Trigger.

Best practice; set a semaphore column which an external process polls.