Bug #31579 Comments in triggers are not being restored after dump
Submitted: 13 Oct 2007 16:23 Modified: 13 Oct 2007 16:27
Reporter: Frank Hieronymi
Status: Duplicate
Category:Server: Backup Severity:S2 (Serious)
Version:5.0.37 OS:Microsoft Windows
Assigned to: Target Version:
Tags: restoring, restore, comment, trigger

[13 Oct 2007 16:23] Frank Hieronymi
Description:
Comments that are being used in triggers (at least here) for documentation purposes of
the code are not being restored after backup generation with mysqldump and restore using
the mysql command line tool. The comments are in the sql-file which is generated by
mysqldump and therefore it seems to be related to the restore process. Tested using
INNODB engine.

How to repeat:
Generate comment in a trigger. Backup using mysqldump. Restore the database using mysql
command line tool.
[13 Oct 2007 16:27] Mark Leith
Hi, 

This is a duplicate of Bug #23002:

http://bugs.mysql.com/bug.php?id=23002