SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Evangelist hessodreamy's Avatar
    Join Date
    Apr 2005
    Location
    uk
    Posts
    518
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    mysqldump not including triggers - privileges?

    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?

  2. #2
    Always A Novice bronze trophy
    K. Wolfe's Avatar
    Join Date
    Nov 2003
    Location
    Columbus, OH
    Posts
    2,079
    Mentioned
    53 Post(s)
    Tagged
    0 Thread(s)
    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.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •