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 can use this simple bash command:
rebird
and MySQL.
For more information, see http://www.upscene.com/go/?go=news&id=20110330
For a full list of fixes in 4.1 releases, see:
http://www.upscene.com/go/?go=tracker&v=4.1.2&id=1
http://www.upscene.com/go/?go=tracker&v=4.1.1&id=1
http://www.upscene.com/go/?go=tr
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
On 30/03/2011 09:05, Brent Clark wrote:
Hiya
Im wondering if someone could help me understand this. If you look at my
two queries below. By the ORDER BY one is using ` and the other ', as a
result, if you do an explain you will see that the top query does a
filesort, while the other does not.
On Wed, 30 Mar 2011 10:05:50 +0200
Brent Clark wrote:
> Hiya
>
> Im wondering if someone could help me understand this. If you look at my
> two queries below. By the ORDER BY one is using ` and the other ', as a
> result, if you do an explain you will see that the top query does a
> filesort,
Hiya
Im wondering if someone could help me understand this. If you look at my
two queries below. By the ORDER BY one is using ` and the other ', as a
result, if you do an explain you will see that the top query does a
filesort, while the other does not.
Would anyone know why.
mysql> explain
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)
>