Thanks all who replied.
After I posted I kept looking and found it... Also had folks point it
out to me.
Your suggestion is what I ended up doing.
Bruce
Gavin Towey wrote:
> Hi Bruce,
>
>
>
> SELECT … INTO OUTFILE always creates the file local to the database
> server. If you want to dum
Hi Bruce,
SELECT ... INTO OUTFILE always creates the file local to the database server.
If you want to dump results where your perl script is running you'll have to
use another method such as receiving the results of the query normally and
writing the file in the perl script.
Regards,
Ga
"Jay Blanchard" <[EMAIL PROTECTED]> wrote:
> [snip]
> Exception occured in Microsoft OLE DB Provider for ODBC Drivers,
> [MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Can't create/write to file
> 'C:\data_out\day234\data_out.txt' (Errcode: 2)
[EMAIL PROTECTED] egor]$ perror 2
System error: 2 = No
As Jay said, it's either a permission issue or the file already exists.
MySQL will not overwrite a file that already exists.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 21, 2004 3:35 PM
To: Mysql General (E-mail)
Subject: RE: SELECT...
-
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: "Mysql General (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, October 21, 2004 10:35 PM
Subject: RE: SELECT... INTO OUTFILE problem
[snip]
Exception occured in Microsoft OLE DB Provider for ODBC Drivers,
[MySQL][ODB
[snip]
Exception occured in Microsoft OLE DB Provider for ODBC Drivers,
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Can't create/write to file
'C:\data_out\day234\data_out.txt' (Errcode: 2)
So I copy the query statement and send via PhpMyAdmin, it ended up as
below
#1 - Can't create/write to file
On Mon, Apr 09, 2001 at 03:48:43PM +0200, Niklas Rudemo wrote:
> I'm trying to select into outfile to a file that already exist.
> This has been discussed before, I know, but the solution suggested
> results in an SQL-error, as shown below. So what's the real solution?
Select your rows into a tem