Alpesh Kothari wrote:
Hi,
I am facing problem while inserting more than 20,000 records using LOAD
DATA INFILE statement through comma seperated file.
Here is my statement:
LOAD DATA LOCAL INFILE '/home/mysql/isa_logs/a.txt' INTO TABLE
FirewallLog_1 FIELDS TERMINATED BY ',';
I have persistantly
On Sat, 15 Jun 2002, Sergey Bondar wrote:
OS Linux Red Hat 7.2
MySql 3.23.41
Hi All!
That is my steps.
With root privileges
I doing:
GRANT ALL ON mydb.* TO client@localhost identified by pwd;
I got:
OK
The user needs the file privilege.
Granting all on mydb.* does not give this
On Fri, 14 Jun 2002, Sergey wrote:
snip
With root privileges
I doing:
GRANT ALL ON mydb.* TO client@localhost identified by pwd;
I got:
OK
snip
Then I doing:
LOAD DATA INFILE /usr/data/myfile INTO TABLE tab01;
I got:
ERROR 1045 Access denied fot user: 'client@localhost' (Using
At 20:23 -0400 6/14/02, Sergey wrote:
OS Linux Red Hat 7.2
MySql 3.23.41
Hi All!
That is my steps.
With root privileges
I doing:
GRANT ALL ON mydb.* TO client@localhost identified by pwd;
I got:
OK
With client privileges !!!
I doing:
mysql -u client -p
passwd
CREATE DATABASE mydb;
I got:
Are you using mysqlimport utility? If not that may be you answer?
If so what flags are you setting?
david
HI ALL: Happy New Year ;)
I have a text file generated from MSAccess database, one of the
fields (Long Text) have Carriage returns within the text, So
the data of some records
I suggest writing a PERL script/filter which accepts the text file and sends
a comma-delimited file to standard-out. This file could then be sucked in
by mysql
-Original Message-
From: Michael Benbow [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 7:48 PM
To: [EMAIL