MESSAGE
| DATE | 2003-04-08 |
| FROM | Ruben Safir
|
| SUBJECT | Re: [hangout] Output file MYSQL
|
/home/joe/sqlfile
On Tue, Apr 08, 2003 at 09:44:14PM -0400, Joe Villari wrote:
> 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
> >
> >
>
>
--
__________________________
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
|
|
