When I restore a backup (.sql) file to the same machine where I made the backup, or on any other mySQL server machine, all comments in stored procedures and functions are stripped out. When I open the backup file in a
text editor, I can see the comments are there. Restore the db, same schema, another schema, doesn't matter- the comments are gone. Seems like the restore is where the comments get lost.
I'm using mySQL 5.0 on...