Re: SCRIPT OR TOOL TO GIVE CHANGES IN DATABASES

2007-08-29 Thread Ananda Kumar
Hi All, Also, i guess u can use tools like TOAD or sqltools to get reports on db changes. regards anandkl On 8/29/07, Edoardo Serra <[EMAIL PROTECTED]> wrote: > > Hi Krishna, >you can use MySQL binlog to see queries that made changes to db > data > > Hope it helps > > Regards > > Krishna

Re: SCRIPT OR TOOL TO GIVE CHANGES IN DATABASES

2007-08-29 Thread Edoardo Serra
Hi Krishna, you can use MySQL binlog to see queries that made changes to db data Hope it helps Regards Krishna Chandra Prajapati ha scritto: Hi All, Is there is any script or tool that generate the report and send an email for changes done in the databases; There is any otherway (man

Re: SCRIPT OR TOOL TO GIVE CHANGES IN DATABASES

2007-08-29 Thread Alex Arul Lurthu
If you want to track the schema level changes, updates, inserts etc you always have the binlogs/update logs. If you want to track select queries also you have the general query log. Check out http://dev.mysql.com/doc/refman/4.1/en/log-files.html for the different logs available. Of course be wary o