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 observed that when
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
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:
OK
CREATE TABLE mytable ( col01
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
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:
OK
CREATE TABLE mytable ( col01
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:
Dear all, I had a problem with load data infile syntax
LOAD DATA INFILE '$file' REPLACE INTO TABLE $table FIELDS TERMINATED BY '|'
that the original data has already carriage returns was considered as new
records in the database, I solved it by using the following syntax:
LOAD DATA INFILE '$file
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 falls in more than one line in the
text file, when I'm using the SQL statement LOAD DATA INFILE...
I have only the
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
PROTECTED]
Subject: Problem with LOAD DATA INFILE
Hello all,
I have a problem. I am able to get a copy of a text file which resides
on another server for a task I am completing. What I need to do is
import this text into a database table on a nightly basis, and I am
trying to set this up via PHP so
Hello all,
I have a problem. I am able to get a copy of a text file which resides
on another server for a task I am completing. What I need to do is
import this text into a database table on a nightly basis, and I am
trying to set this up via PHP so it is all automated. I have one
problem
12 matches
Mail list logo