MESSAGE
| DATE | 2003-04-08 |
| FROM | Joe Villari
|
| SUBJECT | Re: [hangout] Output file MYSQL
|
Try what whole path?
The select into file supposed creates a file on the SQL server. Be
damned if I can find it.
Ruben Safir wrote:
> Try the whole path
>
> On Tue, Apr 08, 2003 at 09:12:55PM -0400, Joe Villari wrote:
>
>>I'm trying to get some data out of a mysql table into a file. I was able
>>to run the command below and it appears that a file named
>>shares_merged.cvs was created. I can't find it anywhere. I ran updatedb
>>and still get no luck using locate.
>>
>>mysql> SELECT * INTO OUTFILE 'shares_merged.cvs'
>> -> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
>> -> FROM ray_merged;
>>Query OK, 970 rows affected (0.02 sec)
>>
>>Tried writing one to my home directory but it looks like I can't write
>>there from mysql.
>>
>>mysql> SELECT * INTO OUTFILE '/home/joev/shares_merged.cvs'
>> -> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
>> -> FROM ray_merged;
>>ERROR 1: Can't create/write to file '/home/joev/shares_merged.cvs'
>>(Errcode: 13)
>>
>>How do I get this data into a file?
>>
>>Joe
>>
>>____________________________
>>NYLXS: New Yorker Free Software Users Scene
>>Fair Use -
>>because it's either fair use or useless....
>>NYLXS is a trademark of NYLXS, Inc
>
>
____________________________
NYLXS: New Yorker Free Software Users Scene
Fair Use -
because it's either fair use or useless....
NYLXS is a trademark of NYLXS, Inc
|
|
