List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 2 1999 8:51pm
Subject:RE: ERROR 3: Error writing file 'UNOPENED' (Errcode: 9)
View as plain text  
At 8:20 AM +1200 8/3/99, Quentin Bennett wrote:
>From: quentin
>To: mysql@stripped
>Subject: [50 character or so descriptive subject here (for reference)]
>
>>Description:
>	ERROR 3: Error writing file 'UNOPENED' (Errcode: 9) performing
>select * from pet into outfile 'fred';
>
>Before
># ls -l /usr/local/var/menagerie
>total 22
>-rw-rw----   1 root     mercury      163 Jul 27 16:32 pet.ISD
>-rw-rw----   1 root     mercury     1024 Jul 27 16:32 pet.ISM
>-rw-rw----   1 root     mercury     8684 Jul 27 16:05 pet.frm
>
>After
># ls -l /usr/local/var/menagerie
>total 22
>-rw-rw-rw-   1 root     other          0 Aug  3 08:16 fred
>-rw-rw----   1 root     mercury      163 Jul 27 16:32 pet.ISD
>-rw-rw----   1 root     mercury     1024 Jul 27 16:32 pet.ISM
>-rw-rw----   1 root     mercury     8684 Jul 27 16:05 pet.frm
>
>>How-To-Repeat:
>	Do the above
>>Fix:
>	None - unable to select ... into outfile at all. Tried '/tmp/fred'
>etc.



You problably don't have the file privilege on the server.

-- 
Paul DuBois, paul@stripped
Thread
ERROR 3: Error writing file 'UNOPENED' (Errcode: 9)Michael Widenius2 Aug
RE: ERROR 3: Error writing file 'UNOPENED' (Errcode: 9)Quentin Bennett3 Aug
RE: ERROR 3: Error writing file 'UNOPENED' (Errcode: 9)Paul DuBois3 Aug
RE: ERROR 3: Error writing file 'UNOPENED' (Errcode: 9)Quentin Bennett3 Aug
RE: ERROR 3: Error writing file 'UNOPENED' (Errcode: 9)Michael Widenius3 Aug
RE: ERROR 3: Error writing file 'UNOPENED' (Errcode: 9)Michael Widenius3 Aug