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

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 <prajapatikc@gmail.com> 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
>

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
>

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 <edoardo.serra@webrainstorm.it> 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/mysql?unsub=anandkl@gmail.com
>
>