Bug #36530 Backup: Restore can fail due to enabled triggers, events
Submitted: 6 May 2008 12:58 Modified: 24 Jul 2008 17:52
Reporter: Lars Thalmann Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Rafal Somla CPU Architecture:Any

[6 May 2008 12:58] Lars Thalmann
If there are enabled triggers and events on the restore server, 
then the restore may fail.

How to repeat:
Code inspection.

Suggested fix:
[22 Jul 2008 14:19] MySQL Verification Team
Thank you for the bug report.
[23 Jul 2008 6:54] Rafal Somla
This bug is fixed by WL#4326 which was pushed into the team tree on 26 Jun (https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-backup&order=14)
and then merged into main 6.0 tree on 16 Jul.
[24 Jul 2008 1:11] Paul DuBois
We need the three-part 6.0.x version number for the fix before we can write the changelog entry.
6.0.7, perhaps?
[24 Jul 2008 17:53] Paul DuBois
Noted in 6.0.7 changelog.

RESTORE could fail if the server on which the restore operation took 
place had enabled triggers or events.