How do I write updates from a table to a text log file in MySQL 5.5 after an insert or update?
Posted on 2011-02-27
I was wondering if anyone had a solution on how to set up a process for writing a new row to a text file once a table has been updated in MySQL 5.5?
I've researched using mysqldump, but I don't think this can be called within MySQL?
Looking at a second option, the INTO OUTFILE can't overwrite existing files.
Basically I have a table and as it is updated, I would like to log a subset of the information in that table to a text log file. The text file should be updated immediately once the insert or update has happened. Preferrably the new row would be concatenated to the existing text file....
Any ideas would be greatly appreciated.