Bug #10431 mysqldump does not dump triggers of the table
Submitted: 7 May 2005 9:54 Modified: 26 Jul 2005 19:49
Reporter: Guilhem Bichot Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.0-bk OS:
Assigned to: Bugs System CPU Architecture:Any

[7 May 2005 9:54] Guilhem Bichot 
Description:
From http://forums.mysql.com/read.php?99,24492
If you do mysqldump on a table which has triggers, these triggers are not printed.
Prevents doing a complete backup of the database.
This is related to http://bugs.mysql.com/bug.php?id=9586
When 9586 is fixed, we can do SELECT FROM the new information_schema table, or maybe some SHOW TRIGGERS FOR TABLE 'x'.
Then mysqldump can be made to call either of the two methods.
So this bug will be worked on only after 9586 is fixed.

How to repeat:
see description
[5 Jul 2005 14:58] Magnus Blåudd 
I have a working patch and is waiting for server support for SHOW TRIGGERS which Antony is working on.
[6 Jul 2005 12:52] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/26716
[15 Jul 2005 10:32] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/27142
[21 Jul 2005 18:09] Patrick Galbraith 
I'll apply this patch to a clean tree and test it since it's ready.
[22 Jul 2005 2:42] Patrick Galbraith 
Pushed this patch.

1.1883 05/07/22 04:11:45 patg@radha.local +3 -0
  Applied and tested this patch successfully (bug 10431)  to a clean 
  tree on brian's amd 64 box (which was already approved). 

  [patg@zim mysql-5.0]$ bk changes
  ChangeSet@1.1882, 2005-07-21 18:43:55+05:00, gluh@eagle.intranet.mysql.r18.ru
    merge fix

  Was the changeset level I applied this patch to.

  Master shutdown finished
  Slave shutdown finished
  All 326 tests were successful.

  [patg@zim mysql-5.0]$
[22 Jul 2005 4:16] Elliot Murphy 
Fix has been pushed for 5.0.11
[26 Jul 2005 19:49] Paul DuBois 
Noted in 5.0.11 changelog, and and entry for the
--triggers option has been added to the mysqldump
section.