SCRIPT OR TOOL TO GIVE CHANGES IN DATABASES

2007-08-29 Thread Krishna Chandra Prajapati
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 (manual) So that i can look that what changes has been done in the database today. Regards, Krishna

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

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

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 Chandra