>>>> 2011/09/03 03:40 +0800, Dennis >>>>
But it seems that there is no "select ... into LOCAL file" statement. Any
suggestion is appreciated.
<<<<<<<<
Indeed: you can use only standard output.
--
MySQL General Mailing List
For
Thanks, Tyler,Â
That's very helpful.
Dennis
--- On Sat, 9/3/11, Tyler Poland wrote:
From: Tyler Poland
Subject: Re: select ... into local outfile ... ???
To: mysql@lists.mysql.com
Date: Saturday, September 3, 2011, 3:45 AM
Dennis,
The following closely simulates the default "IN
the server and the client were on the same machine; now, I need to generate the
output file on client (which is on a different machine from the server). But it seams
that there is no "select ... into LOCAL file" statement.Any suggestion is
appreciated.
Dennis
NATED BY '\n' STARTING
BY '='
FROM d_local.ta, d_news.tbWHERE ta.url_sign = tb.url_sign
Before, the server and the client were on the same machine; now, I need to
generate the output file on client (which is on a different machine from the
server). But it seams that there is no
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
> serve
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.
Re
I have a bit of perl code that ends with an error:
$sql="SELECT convert_tz( a.stamp,'GMT','$tz' ) as ts, a.status,
a.reason, a.tl
INTO OUTFILE '/application/result.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '\"'
LINES TERMINATED BY '\n'
FROM alerts a
hi all...
i have a strange problem with a simple script that is doing select into
outfile...
the thing just does that. it does a select into an outfile. if i print
the query that's passed to mysql_result in the script and then copy it
and paste it z`into the mysql client it works fin
e same meaning as
> the corresponding clauses for LOAD DATA INFILE. See Section 12.2.6, "LOAD
> DATA INFILE Syntax".
> >>
> >> By default, its output to stdout.
> >>
> >> Give it a try !!!
> >>
> >> -Original Message-
> &
>
>> -Original Message-----
>> From: walter harms [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, October 16, 2008 5:06 AM
>> To: 'mysql'
>> Subject: select ... into outfile=stdout ?
>>
>> hi list,
>> i need some options from outfile (exspec
By default, its output to stdout.
>
> Give it a try !!!
>
> -Original Message-
> From: walter harms [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 16, 2008 5:06 AM
> To: 'mysql'
> Subject: select ... into outfile=stdout ?
>
> hi list,
> i need some options
meaning as the
corresponding clauses for LOAD DATA INFILE. See Section 12.2.6, "LOAD DATA
INFILE Syntax".
By default, its output to stdout.
Give it a try !!!
-Original Message-
From: walter harms [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2008 5:06 AM
To: 'mysql
hi list,
i need some options from outfile (exspecialy:FIELDS TERMINATED BY) and would
like
to send the output to stdout to further processing.
unfortunately i found no proper way to force the output to stdout. for now i use
the redirection of the "mysql -NB" output but the interface lacks the opt
pe new lines using select * into outfile
> To: [EMAIL PROTECTED]
> Cc: mysql@lists.mysql.com
> Date: Wednesday, May 14, 2008, 1:35 AM
> Try using:
>
> select * into outfile 'filename.csv' fields
> enclosed by '"' terminated by
> ',' lines
Try using:
select * into outfile 'filename.csv' fields enclosed by '"' terminated by
',' lines terminated by '\n' from table
Regards,
Velen
- Original Message -
From: "Saravanan" <[EMAIL PROTECTED]>
To: "mysql"
mysql
>Subject: how to escape new lines using select * into outfile
>
>Hi all,
>
>I want to export the values based on the condition. I export them as
>csv.
>
>select * into outfile 'filename.csv' from table;
>
>the problem is one field in table has many lines, m
Hi all,
I want to export the values based on the condition. I export them as csv.
select * into outfile 'filename.csv' from table;
the problem is one field in table has many lines, means with \n. I couldn't
import the values into the xls sheet.
any ideas how to escape the new
:
mysqldump: Got error: 1: Can't create/write
to file '/dump1/red1_p2.txt' (Errcode: 13) when executing 'SELECT INTO
OUTFILE'
I'm reading thru http://dev.mysql.com/doc/refman/5.0/en/select.html and it says
that it will not write to an already existing file (so
te to file '/dump1/red1_p2.txt'
(Errcode: 13) when executing 'SELECT INTO OUTFILE'
[EMAIL PROTECTED] /]# ls -l dump1
total 8
-rw-r--r-- 1 root root 742 Feb 22 20:46 red1_p2.sql
[EMAIL PROTECTED] /]# ps axlw | grep mysqld
0 0 8494 1 25 0 3408 944 wait Spts/
what happens when you delete the files that are already in there? Looks
like you're dumping to a file owned by root.
Jed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ed1_p2.txt'
(Errcode: 13) when executing 'SELECT INTO OUTFILE'
[EMAIL PROTECTED] /]# ls -ld /dump1
drwxrwxrwx 2 mysql mysql 4096 Feb 22 19:11 /dump1
[EMAIL PROTECTED] /]# ls -l /dump1
total 16
-rw-r--r-- 1 mysql mysql 29 Feb 22 18:38 foo.bar
-rw-r--r-- 1 root root 742 Feb 22
Mike Spreitzer wrote:
So I am trying to use mysqldump --tab for the first time. I am running
into the same problem everybody does on their first try --- Errcode: 13. I
have set the permissions on the target directory to be completely liberal
--- anybody can do anything with it --- and I still
So I am trying to use mysqldump --tab for the first time. I am running
into the same problem everybody does on their first try --- Errcode: 13. I
have set the permissions on the target directory to be completely liberal
--- anybody can do anything with it --- and I still get Errcode: 13. I
ca
Paul DuBois wrote:
At 10:14 AM -0400 4/13/07, Amer Neely wrote:
I'm using MySQL 5.0.21 and am trying to find out if it is possible to
overwrite an existing file when using a 'SELECT ... INTO' command from
the command line. Is there another parameter that can do this? I've
At 10:14 AM -0400 4/13/07, Amer Neely wrote:
I'm using MySQL 5.0.21 and am trying to find out if it is possible
to overwrite an existing file when using a 'SELECT ... INTO' command
from the command line. Is there another parameter that can do this?
I've looked through
not a
TABLE. Perhaps a better Subject should have been 'How to overwrite
existing file with SELECT .. INTO OUTFILE'.
I think I'll end up writing a Perl script to do this.
On Mon, 16 Apr 2007, Amer Neely wrote:
At 08:14 AM 4/13/2007, Amer Neely wrote:
I'm using MySQL 5.0
t; >> I'm using MySQL 5.0.21 and am trying to find out if it is possible to
> >> overwrite an existing file when using a 'SELECT ... INTO' command from the
> >> command line. Is there another parameter that can do this? I've looked
> >> through
At 08:14 AM 4/13/2007, Amer Neely wrote:
I'm using MySQL 5.0.21 and am trying to find out if it is possible to overwrite
an existing file when using a 'SELECT ... INTO' command from the command line.
Is there another parameter that can do this? I've looked through the onli
Hello Mike,
AFAIK,
What you have specified is applicable only for tables! But for file in
"Select ..into outfile", sure Exit handler is declared when we try to
overwrite an existing file!
Thanks
DEVI.G
- Original Message -
From: "mos" <[EMAIL PROTECTED]>
T
At 08:14 AM 4/13/2007, Amer Neely wrote:
I'm using MySQL 5.0.21 and am trying to find out if it is possible to
overwrite an existing file when using a 'SELECT ... INTO' command from the
command line. Is there another parameter that can do this? I've looked
through the onl
I'm using MySQL 5.0.21 and am trying to find out if it is possible to
overwrite an existing file when using a 'SELECT ... INTO' command from
the command line. Is there another parameter that can do this? I've
looked through the online reference manual, but found no
Yes I can touch the file with the mysql user. The only thing I can't do is a
select into file. However select into file works anywhere else on the
filesystem.
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200 [EMAIL PROTECTED]
-Ori
, March 26, 2007 12:37 PM
To: David Ruggles
Subject: RE: Select into outfile on nfs mount point
>>> Date: Monday, March 26, 2007 11:50:59 AM -0400
>>> From: David Ruggles <[EMAIL PROTECTED]>
>>> To: mysql@lists.mysql.com
>>> Subject: Select into outfile
ECTED]
[mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 12:01 PM
To: David Ruggles
Subject: Re: Select into outfile on nfs mount point
the file on the mount point has to be able to be created, and
read/write by the user that is invoking the mysql call. e.g., if this
is begin done at the comman
m: David Ruggles [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 26, 2007 11:51 AM
> To: mysql@lists.mysql.com
> Subject: Select into outfile on nfs mount point
>
> I'm unable to select into an outfile, the path is in an nfs
> mount point. I'm
> sure it's some s
I'm unable to select into an outfile, the path is in an nfs mount point. I'm
sure it's some sort of permissions issue or something, but I can't figure it
out. I've googled everything I can think of and haven't found anything. Any
help or suggestions would be great
er 09, 2006 2:23 PM
Subject: Charset for SELECT ... INTO OUTFILE
> Hi,
>
> I have a database where the database character set is utf-8 and some rows
> are ascii.
>
> I want to save the results of some queries, and SELECT ... INTO OUTFILE
> looks like an easy way to do it. But I n
Hi,
I have a database where the database character set is utf-8 and some rows
are ascii.
I want to save the results of some queries, and SELECT ... INTO OUTFILE
looks like an easy way to do it. But I need the output in ucs-2. Is there
any way to specify the charset for SELECT ... INTO OUTFILE
From: Mohammed Abdul Azeem Sent: 13 April 2006 07:29
>
> Hi
>
> Iam having a problem using "select into outfile" command, iam getting
> the following error. can anyone help me trace the problem.
>
> mysql> SELECT * INTO OUTFILE'/home/public1/data.txt
Hi
Iam having a problem using "select into outfile" command, iam getting
the following error. can anyone help me trace the problem.
mysql> SELECT * INTO OUTFILE'/home/public1/data.txt' FROM temp_table
WHERE last_time_update = "2006-04-01";
ERROR 1 (HY000):
Lines Terminated By '\r\n' ...
I do get results like 1;2;;4;;2;9 without NULLs or quotes.
Regards, Cor
- Original Message -
From: "Jorrit Kronjee" <[EMAIL PROTECTED]>
To:
Sent: Sunday, April 02, 2006 11:33 AM
Subject: Re: how to suppress NULL values in
;[EMAIL PROTECTED]>
To: "C.R.Vegelin" <[EMAIL PROTECTED]>;
Sent: Saturday, April 01, 2006 6:11 PM
Subject: Re: how to suppress NULL values in SELECT ... INTO OUTFILE ?
At 13:29 +0100 4/1/06, C.R.Vegelin wrote:
Hi everyone,
I am struggling to make a CSV file, with rows like:
o extend the FIELDS options to enable this ...
Regards, Cor
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "C.R.Vegelin" <[EMAIL PROTECTED]>;
Sent: Saturday, April 01, 2006 6:11 PM
Subject: Re: how to suppress NULL values in SELECT ... IN
At 13:29 +0100 4/1/06, C.R.Vegelin wrote:
Hi everyone,
I am struggling to make a CSV file, with rows like: 1;2;;4;;2;9
where NULL values are suppressed in the CSV file.
I tried the following alternatives:
a) Select ... Into Outfile ... Fields Terminated By ';' Escaped By ''
Hi everyone,
I am struggling to make a CSV file, with rows like: 1;2;;4;;2;9
where NULL values are suppressed in the CSV file.
I tried the following alternatives:
a) Select ... Into Outfile ... Fields Terminated By ';' Escaped By ''
Lines Terminated By '\r\n
t.sql';
>
> the result is a file in this path with the content of the table.
> I could think that a malicious user can do several querys like this and fill
> my disk.
> How could I secure this command ?
From the manual:
http://dev.mysql.com/doc/mysql/en/select.html
"The
> the result is a file in this path with the content of the table.
> I could think that a malicious user can do several querys like this and fill
> my disk.
> How could I secure this command ?
According to mysql manual
"The SELECT ... INTO OUTFILE 'file_name' form o
Hi,
I am going to implement a mysql hosting, and I would to make a question,
if a mysql-user with only a "SELECT" privilege make this query:
SELECT * FROM table1 INTO OUTFILE '/mysqldb/data/test.sql';
the result is a file in this path with the content of the table.
I could think that a maliciou
Thomas Spahni wrote:
Hi suomi,
it can be done with a temporary table. See the following example.
Regards,
Thomas Spahni
CREATE TEMPORARY TABLE duptemp SELECT * FROM duprows WHERE id = 2;
ALTER TABLE duptemp CHANGE id id INT NULL;
UPDATE duptemp SET id = NULL;
INSERT INTO duprows SELECT * F
in the
> same table. I got no answer, so there is no such syntax.
>
> now i meant to have found a work-around using (see subject).
>
> problem is, that when i do a SELECT * ... INTO OUTFILE .. i will also
> catch the PRIMARY KEY column if there is one and the LOAD DATA INFILE
>
your PRIMARY KEY is an auto_increment field, just omit foo_ID from
the columns list in both the INSERT and SELECT.
-Original Message-
From: suomi [mailto:[EMAIL PROTECTED]
Sent: Friday, August 19, 2005 7:08 AM
To: mysql@lists.mysql.com
Subject: SELECT ... INTO OUTFILE ... and LOAD DATA
Hi listers
I once asked if there is an SQL syntax permitting to copy a row in the
same table. I got no answer, so there is no such syntax.
now i meant to have found a work-around using (see subject).
problem is, that when i do a SELECT * ... INTO OUTFILE .. i will also
catch the PRIMARY KEY
[snip]
Sometimes I need to execute 'select * into outfile '/tmp/t1.out'
more than 1 times before I get the right result. But once mysql succeeds
in writing t1.out, it does not overwrite it if the same sql command is
executed for the 2nd time unless t1.out is removed. Is
Hi, mysql Gurus,
Sometimes I need to execute 'select * into outfile '/tmp/t1.out'
more than 1 times before I get the right result. But once mysql succeeds
in writing t1.out, it does not overwrite it if the same sql command is
executed for the 2nd time unless t1.out is re
Greetings from Austin, TX:
What is the proper syntax for SELECT INTO OUTFILE
in a statement with a UNION keyword, like the following:
SELECT Addresses FROM editors
UNION
SELECT Addresses FROM authors
Thanks,
Lynn Bender
UnsubCentral
Secure Email List
"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
Hi,
I am sending a query to a MySQL server on a network via LabView EXEC QUERY
VI.
It looks like that
SELECT `data1` , `data2`
INTO OUTFILE 'C:\\data_out\\day234\\data_out.txt'
FIELDS TERMINATED BY '\t'
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
FROM data_table;
What I
2 3
>
> The first row is the column names. The following rows will be the data.
> Those are tabs between the columns.
>
>
>>
>> On 4/6/04 21:43, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
>>
>>> At 20:43 -0500 4/6/04, David L.
column names. The following rows will be the data.
Those are tabs between the columns.
On 4/6/04 21:43, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
At 20:43 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote:
I've scoured the online documentation, and I have a good SELECT
into O
oured the online documentation, and I have a good SELECT into OUTFILE
>> query that gives me what I want... Except that there is no 1st row with
>> column names.
>>
>> Hoping I missed something obvious... Any pointers on this one?
>
> You can't do it with SELE
At 20:43 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote:
I've scoured the online documentation, and I have a good SELECT into OUTFILE
query that gives me what I want... Except that there is no 1st row with
column names.
Hoping I missed something obvious... Any pointers on this one?
You can
I've scoured the online documentation, and I have a good SELECT into OUTFILE
query that gives me what I want... Except that there is no 1st row with
column names.
Hoping I missed something obvious... Any pointers on this one?
--
David L. Van Brunt, Ph.D.
Outlier Consulting & Developme
Chris Fossenier <[EMAIL PROTECTED]> wrote:
>
> It seems that each time we select into an OUTFILE that already exists
> (re-use a name) the server crashes.
>
> Anyone have any ideas if this is a setting or just a bug?
It's known bug:
http://bugs.mysql.com/
It seems that each time we select into an OUTFILE that already exists
(re-use a name) the server crashes.
Anyone have any ideas if this is a setting or just a bug?
Thanks.
Chris.
"Thompson, Jordan" <[EMAIL PROTECTED]> wrote:
> I wan to use a variable for the outfile file name in a select into clause. I am
> doing something like:
>
> set @fileName="/tmp/result.text"
> SELECT col1, col2 INTO OUTFILE @fileName
> FIELDS T
I wan to use a variable for the outfile file name in a select into clause. I am
doing something like:
set @fileName="/tmp/result.text"
SELECT col1, col2 INTO OUTFILE @fileName
FIELDS TERMINATED BY ','
FROM test_table;
the interpreter dies at the @fileName...
if I exchange
MySQL won't write data to a file if the file already exists.
Make sure you've deleted the old file or given MySQL a new
filename to write to.
Jan
--
Janice Wright
Ingenta plc
[EMAIL PROTECTED]
http://www.ingentaselect.com/
Sometime recently Rahmat Hidayat said:
> hello my friends.. i have so
Rahmat> 2. how can i use mysql with delphi?please give me more explanation about it..
and must i have some application for it?
Goto google and find "TmySQL delphi component". You will get the
examples there too.
Ivan
--
hello my friends.. i have some problem :
1. when i drop data out into a file, sometimes i have some problem like the file can't
be opened(when i save into .xls or .mdb or other) how can i solve this problem?
2. how can i use mysql with delphi?please give me more explanation about it.. and must
i
/ __| |/ __| '_ \
| | | | |_) | (_| \__ \ | (__| | | |
|_| |_| .__/ \__,_|___/_|\___|_| |_|@sd.cts.com
|_|
>
>MySQL support: email support
>Synopsis: Problems Using SELECT INTO OUTFILE
>Severity: non-critical
>Priority: medium
>Category: mysql
>Cla
/ __| |/ __| '_ \
| | | | |_) | (_| \__ \ | (__| | | |
|_| |_| .__/ \__,_|___/_|\___|_| |_|@sd.cts.com
|_|
>
>MySQL support: email support
>Synopsis: Problems Using SELECT INTO OUTFILE
>Severity: non-critical
>Priority: medium
>Category: mysql
>Cla
Hello,
I've read documentation and looked in the list archives but
haven't found anything that specifically addresses the idea
of writing out fields in a fixed-field format.
I'd like to do something like "SELECT id,date INTO OUTFILE
'data.txt' id = column 1, date = column 10;" to get a file
th
Andreas,
Thursday, September 12, 2002, 3:56:58 PM, you wrote:
AM> After a query
AM> SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
AM> ENCLOSED BY '"' FROM testtable
AM> the following error occurs:
AM> Error writing file
perror 28
Error code 28: No space left on device
Andreas Metzner wrote:
>Hi All,
>
>After a query
>SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
>ENCLOSED BY '"' FROM testtable
>
>the following error occurs:
>
Hi All,
After a query
SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"' FROM testtable
the following error occurs:
Error writing file 'test.csv' (Errcode: 28)
The file was written partially indeed, but not includin
Hi All,
After a query
SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"' FROM testtable
the following error occurs:
Error writing file 'test.csv' (Errcode: 28)
The file was written partially indeed, but not includin
Yes, I can do that, but the subroutine is the same that execute other
SELECT-like statements. It does:
prepare
execute
fetch result
print
Then it must understand when SELECT * INTO OUTFILE must be executed and do
not try to fetch data.
Is there any criteria that say that there is no data to fetch
, September 09, 2002 12:35 AM
Subject: select * into outfile
> Hello!
>
> I have one subroutine in Perl (DBI) that prepares and executes SELECT-like
> queries and fetches the output from them.
> When I submit SELECT * INTO OUTFILE query, then $sth->fetchrow_array()
> generate
Hello!
I have one subroutine in Perl (DBI) that prepares and executes SELECT-like
queries and fetches the output from them.
When I submit SELECT * INTO OUTFILE query, then $sth->fetchrow_array()
generates Error:
Error 19 (fetch() without execute())
How to avoid it?
How can this subrout
Message -
From: "Wouter van Vliet" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Wouter @ Witbier" <[EMAIL PROTECTED]>
Sent: Friday, August 30, 2002 6:59 PM
Subject: SELECT into :varname
> Heey Folks,
>
> I've been wondering about something fo
Wouter,
Friday, August 30, 2002, 6:59:04 PM, you wrote:
WvV> I've been wondering about something for quite a while now.. I know that it's
WvV> possible in some DBMS's to select a value in some variable, and then in some
WvV> other query use it again. Is this also possiblein MySQL and if so, how?
Sent: Friday, August 30, 2002 5:59 PM
Subject: SELECT into :varname
> Heey Folks,
>
> I've been wondering about something for quite a while now.. I know that
it's
> possible in some DBMS's to select a value in some variable, and then in
some
> other query use it again
Heey Folks,
I've been wondering about something for quite a while now.. I know that it's
possible in some DBMS's to select a value in some variable, and then in some
other query use it again. Is this also possiblein MySQL and if so, how?
Thanks,
Wouter
-
Hmm .. isn't there any workaround for this .. Maybe something like:
select count(*) into :somerVar FROM table;
update sekce set pocet = :someVar WHERE ... blabla;
I've seen things like this in other databas servers but haven't been able to
find out if it's supported by MySQL, and
Hi,
I'm trying to do the following:
select * into outfile '/tmp/data.txt' fields terminated by';' from customer
Although the mysql-user has all privileges (except the grant priv) on the database
and the file_priv in the user table I get an 'Access denied for use
Hello.
On Fri, May 31, 2002 at 02:08:57AM +0100, [EMAIL PROTECTED] wrote:
[...]
> BP> So you may consider upgrading and check if you find the problems
> BP> still reproducable.
[...]
> I generally only update on a needs basis, most notably for security,
> as I like to keep things stable and conse
Benjamin,
In response to your mail of Friday, May 31, 2002 1:24:17 AM:
BP> Hello.
Thanks for the feedback.
BP> 3.23.36 is a bit outdated by now
Sure -- actually that's why I was vague about the side-issue (below)
and why I checked the changelogs for an explicit fix to my main
problem.
BP>
Hello.
On Thu, May 30, 2002 at 10:52:46PM +0100, [EMAIL PROTECTED] wrote:
> Hi,
>
> (FYI: "mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386)")
3.23.36 is a bit outdated by now (more than a year old) and there have
been several bug fixes regarding GRANT/REVOKE since then. So you may
c
Hi,
(FYI: "mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386)")
After extensive testing, I have found that: -
(a) [SIDE ISSUE]
Logged-in as a user (using password) and modifying privileges in
another MySQL (root) session, even with "flush privileges", the
privileges do not
On Mon, 6 May 2002 07:44:04 +0200
"Ewan Sadie" <[EMAIL PROTECTED]> wrote:
> I have installed MySQL on two of my MS-Proxy servers. I am logging all
> web browser logs to MySQL.
> I want to replicate the database to a central server where I can do
> queries on the data. I do not want to run select
I am not sure on this one, since I am new to mysql myself.
But how about just entering the appropriate information on the other
host before the database name
i.e. hostname.databasename.tablename
Don't know how or where to privide the user name/pw for tthe 2nd.
server though.
It's just an idea
I have installed MySQL on two of my MS-Proxy servers. I am logging all
web browser logs to MySQL.
I want to replicate the database to a central server where I can do
queries on the data. I do not want to run select statement agains the
proxy server itself.
How can I replicate the data to a differ
Hi,
i am using mysql 4.0.0 version -alpha in windows 2000.
i'd like to export the mysql table data to excel format.
So,i use the outfile method.
mysql>select * into outfile 'backup.xls' from ;
When i open 'backup.xls' in microsoft excel,i can view all the data ,but i
c
I have been assigned the fun little job of porting a (very badly
designed) database from Access97 to MySQL so that we'd finally get
rid of that pesky Win2000-server.
The database contains a list of magazines currently in our basement
waiting for someone to borrow them. There are, at the moment, j
t!
Sorry, why would you expect it to work? It's not a legal
statement in MySQL.
> Regards.
> kamal
>
> >Hi,
> >
> >Is there a reason why, if I can
> >
> >LOAD DATA LOCAL INFILE 'file' INTO TABLE fred;
> >
> >why I can't
>
LE 'file' INTO TABLE fred;
>
>why I can't
>
>SELECT * INTO LOCAL OUTFILE '/tmp/file.txt' FROM fred
Because it's just never been implemented.
>
>I know the data has to travel to the client, but it would make scripting
>easier!
>
-
At 8:28 AM +1300 11/28/01, Quentin Bennett wrote:
>Hi,
>
>Is there a reason why, if I can
>
>LOAD DATA LOCAL INFILE 'file' INTO TABLE fred;
>
>why I can't
>
>SELECT * INTO LOCAL OUTFILE '/tmp/file.txt' FROM fred
Because it's just never b
1 - 100 of 117 matches
Mail list logo