Hi all!
John G. Heim wrote:
> From: "Claudio Nanni"
> [[...]]
>
>
>> 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'
From: "Claudio Nanni"
To: "Shawn Green (MySQL)"
Cc: "John G. Heim" ;
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 ca
t;
> To: "Shawn Green (MySQL)"
> Cc: "John G. Heim" , 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 comment
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)
>
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 code
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 marke
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
proc
