Anthony Ettinger wrote:
>Turns out I forgot the gzip > filename, only had | gzip filename.
>
>But the real problem here is I'm getting packet loss and loosing my
>connection, which is probably why I get that error 32.
>
>
>
>On 1/5/06, Anthony Ettinger <aettinger@stripped> wrote:
>
>
>>I am, I'm running a remote command mysqldump | gzip > some file.
>>
>>
>>On 1/5/06, Logan, David (SST - Adelaide) <David.Logan@stripped> wrote:
>>
>>
>>>Hi,
>>>
>>>Are you running mysqldump through into a pipe eg: into tar or similar? I
>>>mention this because :
>>>
>>>test1=>perror 32
>>>System error: 32 = Broken pipe
>>>
>>>Regards
>>>
>>>
>>
>>---------------------------------------------------------------
>>
>>
>>>********** _/ ********** David Logan
>>>******* _/ ******* ITO Delivery Specialist - Database
>>>***** _/ ***** Hewlett-Packard Australia Ltd
>>>**** _/_/_/ _/_/_/ **** E-Mail: david.logan@stripped
>>>**** _/ _/ _/ _/ **** Desk: +618 8408 4273
>>>**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
>>>***** _/ ******
>>>****** _/ ******** Postal: 148 Frome Street,
>>>******** _/ ********** Adelaide SA 5001
>>> Australia
>>>i n v e n t
>>>---------------------------------------------------------------
>>>
>>>-----Original Message-----
>>>From: ettinger@stripped [mailto:ettinger@stripped] On Behalf Of
>>>Anthony Ettinger
>>>Sent: Friday, 6 January 2006 2:17 PM
>>>To: mysql@stripped
>>>Subject: mysqldump: Got errno 32 on write ?
>>>
>>>"mysqldump: Got errno 32 on write" -- any ideas? I think it may
>>> be mysqldump is not run as user, because dump dir is
>>>0700??
>>>
>>>--
>>>Anthony Ettinger
>>>Signature: http://chovy.dyndns.org/hcard.html
>>>
>>>
>>>
>>
>>--
>>Anthony Ettinger
>>Signature: http://chovy.dyndns.org/hcard.html
>>
>>
>>
>
>
>
>--
>Anthony Ettinger
>Signature: http://chovy.dyndns.org/hcard.html
>
>
>
Hi Anthony,
Are you running the mysqldump from one host and gzipping on another?
This could be the result of a network issue. Another thing to check is
the size of your mysqldump, some versions of gzip (certainly the older
ones) have size limitations. You may be busting these.
Regards
--
David Logan
South Australia
when in trouble, or in doubt
run in circles, scream and shout
