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
