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.
Hi Frank,
ReplyDeleteI'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,
ReplyDeleteI 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.
ReplyDeleteI'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.