From: "Claudio Nanni" <claudio.na...@gmail.com> To: "Shawn Green (MySQL)" <shawn.l.gr...@oracle.com> Cc: "John G. Heim" <jh...@math.wisc.edu>; <my...@lists.mysql.co 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/mysql?unsub=arch...@jab.org
