From: Johan De Meersman
Date: March 30 2011 8:47am
Subject: Re: getting procedure code via mysqldump
List-Archive: http://lists.mysql.com/mysql/224726
Message-Id: <3a11bcf2-4d85-4ceb-9143-4f74a5fd026b@zimbra>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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.nanni@stripped>
> To: "Shawn Green (MySQL)" <shawn.l.green@stripped>
> Cc: "John G. Heim" <jheim@stripped>, mysql@stripped
> 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.green@stripped>
> 

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel