MESSAGE
| DATE | 2003-04-08 |
| FROM | Ruben Safir
|
| SUBJECT | Re: [hangout] Output file MYSQL
|
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
--
__________________________
Brooklyn Linux Solutions
__________________________
DRM is THEFT - We are the STAKEHOLDERS http://fairuse.nylxs.com
http://www.mrbrklyn.com - Consulting
http://www.inns.net <-- Happy Clients
http://www.nylxs.com - Leadership Development in Free Software
http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net
http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn....
1-718-382-0585
____________________________
NYLXS: New Yorker Free Software Users Scene
Fair Use -
because it's either fair use or useless....
NYLXS is a trademark of NYLXS, Inc
|
|
