Bug #15555 Triggers not backed up

• Submitted: 7 Dec 2005 18:25
• Modified: 28 Aug 2006 9:27
• Reporter: Apolo Meza
• Status: Closed
• Category: MySQL Administrator
• Severity: S2 (Serious)
• Version: 1.1.5
• OS: Windows (Windows XP)
• Assigned to: Mike Lischke
• CPU Architecture: Any
• Tags: Backup

[7 Dec 2005 18:25] Apolo Meza

Description:
When backing up a database the triggers are not included in the backup.

How to repeat:
Create a trigger.
Backup the database the trigger was created in.
Delete the database or restore the database on a different machine.
The trigger is not present where you performed the restore operation.

I see that the trigger is actually stored in the information_schema database, but shouldn't the triggers for a database be included in it's backup?

Suggested fix:
Include triggers in the backup of a database.

[7 Dec 2005 18:43] MySQL Verification Team

Thank you for the bug report.

[13 Jul 2006 3:45] Jared S

I confirm the problem with 1.1.9 for Windows XP

[18 Jul 2006 0:23] Jared S

WTF bug submitted 2005 an is 'In progress'?

[24 Jul 2006 7:14] Sveta Smirnova

We have duplicate Bug #21240

[26 Jul 2006 13:06] Mike Lischke

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://www.mysql.com/doc/en/Installing_source_tree.html

[22 Aug 2006 23:32] Jared S

Would help me if I knew versions of the planned release fix.

ie. MySQL 5.0.25 & MySQL 5.1.12?

[23 Aug 2006 6:53] Mike Lischke

The release of the tools bundle has nothing to do with the server releases so grab a copy of the just released tools bundle and you should have that fix. Mike Zinner announced the release two days ago in our forums.

[23 Aug 2006 22:37] Jared S

MySQL Administrator 1.2.2 Beta from latest release of gui-tools still does not backup my Trigger.

Please fix, or give me necessary instructions for backing up a Trigger on a windows box.

[24 Aug 2006 12:53] Mike Lischke

Triggers are only written out if a full backup is performed. Need to enable triggers for all selected tables (if not a full backup).

[28 Aug 2006 9:27] Mike Lischke

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

[28 Aug 2006 22:49] Jared S

Could the 'Complete Backup' setting be checked by default on normal install of Adminstrator?

Will I need to put another request in for that?