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
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
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.com
Sent: Wednesday, March 30, 2011 2:01 AM
Subject: Re: getting procedure code via mysqldump
In case you use a linux or unix system
Hi all!
John G. Heim wrote:
From: Claudio Nanni claudio.na...@gmail.com
[[...]]
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
I would like to use mysqldump to get a copy of the code for a stored
procedure in a format that is similar to the code I used to create it. The
problem is that I'm blind and I have to listen to the code to debug it. I
think I have a file containing the code that I used to create the stored
Hi John,
The lines you mention are comments , the comments in mysql sql files are
enclosed between two delimiters. The first is the sequence /* and the second
is the sequence */ , inside the comments you can have a marker constituted
by a ! and a number that represents a mysql version. These
On 3/29/2011 19:09, John G. Heim wrote:
I would like to use mysqldump to get a copy of the code for a stored
procedure in a format that is similar to the code I used to create it.
The problem is that I'm blind and I have to listen to the code to debug
it. I think I have a file containing the