• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1702
  • Last Modified:

mysql triggers

When I try to backup my db using mysqldump which i've always used successfully, I get this:

ERROR 1235 (42000) at line 330: This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

I do not have multiple triggers on a table that it fails on... can someone please explain or try to help?

1 Solution
This sounds like it might be an interaction between mysqldump and mysql itself.  Which version/platform of mysql are you using and does the version of mysqldump match?  Also, are you running a version of mysql that has been upgraded (or downgraded) from a different version?
Muhammad WasifCommented:
This seems to be a bug as already reported. See if this is the case with you
bug #39989
bug #44665
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now