Re: SCRIPT OR TOOL TO GIVE CHANGES IN DATABASES

[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 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 (manual) So that i can look that what changes has
> been
> > done in the database today.
> >
> > Regards,
> > Krishna
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

Re: SCRIPT OR TOOL TO GIVE CHANGES IN DATABASES

[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 (manual) So that i can look that what changes has been
done in the database today.

Regards,
Krishna



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SCRIPT OR TOOL TO GIVE CHANGES IN DATABASES

[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 of the performance implications.

-- 
Alex
http://alexlurthu.wordpress.com/

On 8/29/07, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> 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
>