I noticed that my mysqldump files weren’t including triggers, though I thought trigger inclusion was there by default, and still doesn’t when I explicitly specify to include triggers. It turns out that they’re included when I log in as root, but not when logged in as a reporting user. Is there a specific privilege I need to grant to allow the inclusion of triggers in the mysqldumps?
After doing some reading on replication last week, I learned that you need to avoid things such as triggers (I believe it was on xaprb.com but I can’t find the article) as they don’t always translate to the slave.
Try to move the functions of your triggers to your front end of the application so that you can avoid this problem.