Might it not be easier to use something like "show create procedure" instead? Given that the purpose is debugging, I would assume you want the exact text used to create the procedure, not the one with version-specifics removed.
You can still pump that into a file by using "mysql -e 'show create procedure procname\G' dbname > outputfile.sql". There will still be a bit of superfluous information as this is an information request, but that should be easily removed with some sed hacking. ----- Original Message ----- > From: "Claudio Nanni" <claudio.na...@gmail.com> > To: "Shawn Green (MySQL)" <shawn.l.gr...@oracle.com> > Cc: "John G. Heim" <jh...@math.wisc.edu>, mysql@lists.mysql.com > Sent: Wednesday, 30 March, 2011 9:01:06 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 > > this will create a new dump without comments. > > Cheers > > Claudio > > > 2011/3/30 Shawn Green (MySQL) <shawn.l.gr...@oracle.com> > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
