How to fetch the data from binary log file and insert in our desired table in MySQL?

Posted by Parth on Stack Overflow See other posts from Stack Overflow or by Parth
Published on 2010-03-26T09:05:18Z Indexed on 2010/03/26 9:33 UTC
Read the original article Hit count: 447

Filed under:
|

How to fetch the data from binary log file and insert in our desired table in MySQL?

I am on my way of scripting a PHP code for Audit Trail, in this I encountered a situation that if there will be new table created then I will not be available with triggers for that new table and hence no tracking could be done for that, so if I code it to create three new triggers for this new table, then how will get the last change done in this table? Hence I found that Binary Log File can be helpfull for me in this case, to fetch the last change for this new table and insert it in tracking table... BUT HOW????

© Stack Overflow or respective owner

Related posts about mysql

Related posts about binary