how to trace the database (update,add,edlete etc)

[expired user #8207]'s profile image [expired user #8207] posted 10 years ago in General Permalink
hi
may i ask, is it possible to trace the database (update,add,edlete etc).
for example,i'd like to know for one table,when its data is updated,(better i can also trace the Ip adrress etc)
is it possible?
thank u very much
ansgar's profile image ansgar posted 10 years ago Permalink
Yes, but that's not a feature in HeidiSQL. You can activate logging on the server to get *each* and *every* query into some textfile.

Please login to leave a reply, or register at first.