MESSAGE
| DATE | 2003-04-08 |
| FROM | Ruben Safir
|
| SUBJECT | Re: [hangout] Output file MYSQL
|
From owner-hangout-desteny-at-mrbrklyn.com Tue Apr 8 21:41:38 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 h391fcrt027382 for ; Tue, 8 Apr 2003 21:41:38 -0400
Received: (from mdom-at-localhost) by www2.mrbrklyn.com (8.12.3/8.12.3/Submit) id h391fcje027381 for hangout-desteny; Tue, 8 Apr 2003 21:41:38 -0400
X-Authentication-Warning: www2.mrbrklyn.com: mdom set sender to owner-hangout-at-www2.mrbrklyn.com using -f
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 h391fbrt027375; Tue, 8 Apr 2003 21:41:37 -0400
Received: (from ruben-at-localhost) by www2.mrbrklyn.com (8.12.3/8.12.3/Submit) id h391fbMr027374; Tue, 8 Apr 2003 21:41:37 -0400
Date: Tue, 8 Apr 2003 21:41:37 -0400
From: Ruben Safir
To: Joe Villari
Cc: Ruben Safir , Hangout
Subject: Re: [hangout] Output file MYSQL
Message-ID: <20030409014137.GA27362-at-www2.mrbrklyn.com>
References: <3E937397.8070203-at-pipeline.com> <20030409013648.GB27221-at-www2.mrbrklyn.com> <3E937AEE.2040804-at-pipeline.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <3E937AEE.2040804-at-pipeline.com>
User-Agent: Mutt/1.3.27i
Sender: owner-hangout-at-mrbrklyn.com
Precedence: bulk
Reply-To: Ruben Safir
List: New Yorkers Linux Scene
Admin: To unsubscribe send unsubscribename-at-domian.com to hangout-request-at-www2.mrbrklyn.com
X-Evolution: 00000297-0000
X-Keywords:
X-UID: 10952
Status: RO
Content-Length: 2006
Lines: 68
/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
|
|
