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 14:23	Modified:	13 Oct 2007 14:27
Reporter:	Frank Hieronymi	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Backup	Severity:	S2 (Serious)
Version:	5.0.37	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	comment, restore, restoring, trigger

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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