MySQL Bugs: #31579: Comments in triggers are not being restored after dump

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log

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.

Hi, 

This is a duplicate of Bug #23002:

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