From: "Claudio Nanni" <[email protected]> To: "Shawn Green (MySQL)" <[email protected]> Cc: "John G. Heim" <[email protected]>; <[email protected] m> Sent: Wednesday, March 30, 2011 2:01 AM Subject: Re: getting procedure code via mysqldump
In case you use a linux or unix system, to strip off the comments in linux bash is very easy, you can use this simple bash command: grep -v "^/\*" yourdumpfile.sql > yourdumpfilewithoutcomments.sql
That didn't work because there are comments embedded in the line that creates the procedure. For example:
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `TIMETABLE_SYNC`()
That's all one line. It will probably wrap in my message. But the line begins with a /* so its removed by your grep command.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
