Tag Info

New answers tagged

0

What i did is : i used existing my.cnf file and copy it in another location and edit some part of it : 1. Commented #port=3306 2. Added these lines at the end. [mysqld1] basedir ="C:\Program Files (x86)\MySQL\MySQL Server 5.6" port = 3307 enable-named-pipe socket = ...


0

You can use CDC(Change Data Capture) It will track changes. But if you alter the table, CDC Will not work.. you can handle this by ... 1. Copy all data from change table to another table... 2. Disable CDC For that table.. 3. Alter table... 4 Enable CDC For that Table.. CDC Works fine. it is assynchronous with transactions. --Enable ...


0

I won't use a own product for this. You have two simple ways to do it on your own. You can use CDC (Change-Data-Capture) which will do this automatically. You can retrieve the changes afterwards for some time. (If you don't need that every value is hold back for ever) You can create an Before-Update trigger, which will generate a own log for a record ...



Top 50 recent answers are included