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" <[email protected]> > To: "Shawn Green (MySQL)" <[email protected]> > Cc: "John G. Heim" <[email protected]>, [email protected] > 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) <[email protected]> > -- 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/[email protected]
