So Mike, from now on you don't have to penalize me by not posting a comment. I am pleased to announce that comments are now open to anyone, not just the registered blogger.com users.
Big thanks to the following for their almost immediate support.
- Mike Hillyer for "Updating Another Table With MySQL Triggers"
- Markus Popp for Creating log tables with triggers (Somehow read my mind)
- Kristian Köhntopp for Triggers maintaining summaries: Kristian shows us how to
"have a users table with a summary field, and a detail table with a value field. When records are inserted, modified or deleted with changing values in the detail table, the matching summaries in the users table are updated."
- Scott Noyes for his comment
- Roland for his tips and the following comment:
That's amazing - almost like a chain reaction! Suddenly, everybody at Planet MySQL is writing something on triggers.
It amazed me too. Seemed like everyone was waiting to talk about it and I just pulled the "trigger" :) - Sheeri and Ronald for their comments on "How to convince a DBA?".
Hopefully I didn't miss anyone.
As can be evident from the above, the MySQL community rocks!
Thanks
Frank
-----------
P.S. I accidentally misspelled Roland Bouman's name when thanking him earlier in this post. Roland, I sincerely regret the error.
3 comments:
Hi Frank,
I'm devising a little tutoral trigger machine of my own. With some extension/modification, it could actually be of some use, at least I hope so.
It will appear on the my blog maybe tonight, or else somewhere around the weekend.
(BTW: Roland != Ronald. There is also a Ronald: Ronald Bradford. To add to the confusion: my family name is Bouman, so both my and Ronald's initials are R.B.)
Hi Roland,
I look forward to the "tutorial trigger machine."
Sorry for the typo. I've corrected it.
Thanks again,
Frank
Ronald Bracho wrote: your blog is great and very helpfull.
I'd like to post the following question: I have mysql 5.0.48 running with several DBs, which have several Triggers and Store Procedures. At the moment I'm in the need to take my DB's(triggers and Procedures along) to a new server for migration purposes: The problem is that I can't find a command in mysql that allows me to backup everything all together and afterwards be able to restore everything in the new server. Not even MySQL Administrator helped.
Please advice: ronaldbracho@gmail.com or normalejandra20@gmail.com
Thank you in advance.
PS: a software recommendation that can do this will be also appreciated.
Post a Comment