Thanks for the reply, but I need a binary transfer of the DATA in the
field only. INTO OUTFILE does 2 things that corrupt the data:
1. Puts field data in the file
2. Escapes characters.
As far as I can tell, I either have to use "INTO DUMPFILE" or I need to
write a C program to do what I need.
Any other suggestions?
-Bill
Robin Keech wrote:
>
> use
> SELECT * INTO OUTFILE 'filename' .....
>
> -----Original Message-----
> From: Bill Moran [mailto:[EMAIL PROTECTED]]
> Sent: 09 May 2001 00:44
> To: [EMAIL PROTECTED]
> Subject: Problem using "SELECT INTO DUMPFILE"
>
> I get an error stating: "you have an error in your SQL syntax near
> 'dumpfile '/data/file.doc''"
>
> The command I'm trying to execute is:
> select resume from apps where appid=23 into dumpfile '/data/file.doc'
> The server and client are on two different computers.
>
> I'm using client version 3.23.36 on machine redfs
> Server version 3.22.32 on machine redsql
>
> Do I need to upgrade the server before this will be possible? I
> understand that SELECT INTO DUMPFILE must put the file on the local
> machine, but does that mean when running the client on redfs, I'm trying
> to put the file on redsql? (just thought of this, but it would be weird
> to get that particular error if that were the case) That wouldn't work,
> since there is no /data directory on redsql. If that's the problem, I
> suppose I'll have to establish a NFS mount.
>
> Any pointers are welcome. Please keep me in the CC box as I'm not
> currently subscribed to this list.
>
> TIA,
> Bill
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
