Link to home
Create AccountLog in
Avatar of marrowyung
marrowyung

asked on

MySQL change alert.

Dear all,

Any way to make MySQL server send an email alert (by operators) if any database structure change and what it is ?

Any third party tools needs for this ?

DBA100.
Avatar of _-MYFOX-_
_-MYFOX-_
Flag of Italy image

Avatar of marrowyung
marrowyung

ASKER

That one is not about database structure change but data inside change ,just like a row has been added.

I just want the database/table structure change.
That one don't even tell what field has been changed. who did it and what is the query, time stamp etc...
ASKER CERTIFIED SOLUTION
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Ray_Paseur,

In MS SQL we can do something like DDL triggering, so in MySQL, it is not going to exists even MySQL 5.5 enterprise ?

data base structure change can be something like:
1) a column has been added.
2) an index has been added,

etc..

"SHOW CREATE TABLE"

this statement just show the CREATE TABLE statement that creates the given table, it should have nothing to do with this, right?

where should I store the md5() digest of this string ? in a table ?

But this one still don't tell what has been changed, who change it and the command make this happen, the time create it.. rihgt?
please also unlock my ability ask question agian, I have already close many.
@marrowyung: I want an explanation of why you gave the worst possible grade anyone can give at Experts-Exchange.  I tried to tell you that there was nothing built-in to do what you want.  You're asking for a pink unicorn.  There are no pink unicorns, full stop.  At that point you must have understood that you were on the threshold of application development, and that there was no "quick and easy" answer.  Just because you asked a question for which there is no answer, that is not any sort of justification for giving a bad grade.

Please see the grading guidelines here:
https://www.experts-exchange.com/help/viewHelpPage.jsp?helpPageID=26
The asker must justify giving a C grade
In addition to your justification of the grade, it would be helpful if you would explain why I should try to help with any of your questions in the future.