MESSAGE
| DATE | 2003-04-08 |
| FROM | Joe Villari
|
| SUBJECT | Subject: [hangout] Output file MYSQL
|
From owner-hangout-desteny-at-mrbrklyn.com Tue Apr 8 21:09:29 2003
Received: from www2.mrbrklyn.com (localhost [127.0.0.1]) by mrbrklyn.com (8.12.3/8.11.2/SuSE Linux 8.11.1-0.5) with ESMTP id h3919Trt026880 for ; Tue, 8 Apr 2003 21:09:29 -0400
Received: (from mdom-at-localhost) by www2.mrbrklyn.com (8.12.3/8.12.3/Submit) id h3919TRK026879 for hangout-desteny; Tue, 8 Apr 2003 21:09:29 -0400
X-Authentication-Warning: www2.mrbrklyn.com: mdom set sender to owner-hangout-at-www2.mrbrklyn.com using -f
Received: from blount.mail.mindspring.net (blount.mail.mindspring.net [207.69.200.226]) by mrbrklyn.com (8.12.3/8.11.2/SuSE Linux 8.11.1-0.5) with ESMTP id h3919Srt026874 for ; Tue, 8 Apr 2003 21:09:29 -0400
Received: from user-2iveb1t.dialup.mindspring.com ([165.247.44.61] helo=pipeline.com) by blount.mail.mindspring.net with esmtp (Exim 3.33 #1) id 193486-0003GF-00 for hangout-at-nylxs.com; Tue, 08 Apr 2003 21:11:58 -0400
Message-ID: <3E937397.8070203-at-pipeline.com>
Date: Tue, 08 Apr 2003 21:12:55 -0400
From: Joe Villari
User-Agent: Mozilla/5.0 (X11; U; Linux ppc; en-US; rv:0.9.9) Gecko/20020604
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Hangout
Subject: [hangout] Output file MYSQL
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Sender: owner-hangout-at-mrbrklyn.com
Precedence: bulk
Reply-To: Joe Villari
List: New Yorkers Linux Scene
Admin: To unsubscribe send unsubscribename-at-domian.com to hangout-request-at-www2.mrbrklyn.com
X-Evolution: 00000289-0000
X-Keywords:
X-UID: 10956
Status: RO
X-Status: A
Content-Length: 920
Lines: 29
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
|
|
