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 Windows XP
This is a fairly annoying 'feature', since other's may have to view/modify these
procs and funtions, and there is nothing to explain what's going on in the code.
6 months after I write a complicated proc or function, I won't even remember what my thought process was at the time I wrote the code.
Any insight would be appreciated, thanks.