Hi all,
I've a question, i need to killing a load data in file. Normally used
show processlist and kill PID. But don't work.
any idea?
Thanks :D
{ name : Rafael Valenzuela,
open source: [Saiku Admin Console,Anaytical Sport],
location : Madrid Spain,
twitter : [@sowe
2013/12/18 11:07 -0500, Anthony Ball
I ran across a curious issue, I'd call it a bug but I'm sure others would
call it a feature.
I have a csv file with space between the and , and it causes MySQL to eat
that field and the field after it as a single field. Is there a setting I
can use to
I ran across a curious issue, I'd call it a bug but I'm sure others would
call it a feature.
I have a csv file with space between the and , and it causes MySQL to eat
that field and the field after it as a single field. Is there a setting I
can use to remedy this or do I just have to make sure
(1)
yes it is an issue even i faced. for the remedy i search the {( ,) (,)}
values of , space between and , replaced by , in .csv itself.
(2)
The other way is, if all the values are like space between , then you can
use space and , in fields terminated by
LOAD DATA LOCAL INFILE
Hello,
after switching from MySQL 5.0.67 to 5.1.59 we get the following problem:
We want to import data from a textfile
example of the textfile:
t...@test.com$yes$432145$xyz
The command is: LOAD DATA LOCAL INFILE 'textfile.txt' INTO TABLE TESTTABLE
FIELDS TERMINATED BY '$';
Selecting the
mysql 5.1.53 after i see
some post on the internet saying we have some issues in the older version ,
but it keeps giving the same error.
thanks
Anand
On Mon, Dec 20, 2010 at 7:42 PM, who.cat win@gmail.com wrote:
i wanna know you have done LOAD DATA INFILE in master ,why are you tring
to do
Hi guys,
i am facing a serious issue with my replication , i tried so many things but
no luck.
my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
we run LOAD DATA INFILE in master to process some csv files and load it into
a table, it runs perfectly well in master
DATA INFILE in master to process some csv files and load it into
a table, it runs perfectly well in master but when it comes to slave it
stops with SQL SYNTAX error
i tried running the LOAD DATA INFILE manually on the slave , but it says
different error as below
mysql load data infile '/tmp
On Mon, Dec 20, 2010 at 9:00 AM, Anand anand@gmail.com wrote:
Hi guys,
i am facing a serious issue with my replication , i tried so many things
but no luck.
my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
we run LOAD DATA INFILE in master to process some
Hello,
I have a question about the execution cycle of LOAD DATA INFILE.
If I issue a large file via LDI LOCAL, I know that the file is copied to
the MySQL server and executed there.
But at what point does the statement finish from the sender's point of view?
1) When the file is successfully
: Monday, October 25, 2010 12:16 PM
To: mysql@lists.mysql.com
Subject: Load Data Infile Errors
Hello,
I have a question about the execution cycle of LOAD DATA INFILE.
If I issue a large file via LDI LOCAL, I know that the file is copied to
the MySQL server and executed there.
But at what point
Data Infile, but the unique and
primary indexes will be built as the data is being loaded and this is going
to slow down the import.
There is no point doing a Disable Indexes on the table because this only
affects non-unique indexes and that is already taken care of since the table
is already
an Alter Table .. add index
for all of the indexes?
Or is it faster to just leave the indexes in place prior to loading the
data.
I know if the table is empty and optimized, the non-unique indexes will
be
built AFTER the data is loaded using Load Data Infile, but the unique
for all of the indexes?
Or is it faster to just leave the indexes in place prior to loading the data.
I know if the table is empty and optimized, the non-unique indexes will be
built AFTER the data is loaded using Load Data Infile, but the unique and
primary indexes will be built
will
be built AFTER the data is loaded using Load Data Infile, but the unique
and primary indexes will be built as the data is being loaded and this
is going to slow down the import.
There is no point doing a Disable Indexes on the table because this only
affects non-unique indexes
At 05:40 AM 10/18/2009, John wrote:
Mike,
What behaviour you experience depends to some extent on what storage engine
you are using and on what other non-unique indexes you have on the tables.
With LOAD DATA INFILE on empty MyISAM tables all non-unique indexes are
created in a separate batch
Mike,
What behaviour you experience depends to some extent on what storage engine
you are using and on what other non-unique indexes you have on the tables.
With LOAD DATA INFILE on empty MyISAM tables all non-unique indexes are
created in a separate batch which makes it much faster if you have
I'm trying to speed up Load Data Infile and after some experimenting have
noticed this qwirk.
BTW, all of the tables used below are empty and have identical table
structures. The value being loaded into the primary key column is 'NULL'.
Test1:
246 seconds to run Load Data Infile into a table
like to import the first file field to the second table
field, the second file field to the third table,... Just to have an index.
I'm using:
| LOAD DATA INFILE 'test.csv' INTO TABLE table
| FIELDS TERMINATED BY ','
| LINES STARTING BY '' TERMINATED BY '\n'
| (Page, Device, GROUP , ItemID
Group is a keyword in mysql:
You need to put backticks around it in your statement:
| LOAD DATA INFILE 'test.csv' INTO TABLE table
| FIELDS TERMINATED BY ','
| LINES STARTING BY '' TERMINATED BY '\n'
| (Page, Device, `GROUP` , ItemID, Item, Value);
On Mon, Jun 29, 2009 at 7:07 AM, Ralph
Johnny Withers schrieb:
Group is a keyword in mysql:
You need to put backticks around it in your statement:
| LOAD DATA INFILE 'test.csv' INTO TABLE table
| FIELDS TERMINATED BY ','
| LINES STARTING BY '' TERMINATED BY '\n'
| (Page, Device, `GROUP` , ItemID, Item, Value);
Ooookay
Hi,
I've been trying to import a 10G dump file using mysqlimport
and it is eventually failing because it runs out of tmpdir
space -- I get Errcode: 28.
I was surprised that it was using a temp file at all. I've
looked in the documentation and other sources but have not been
able to find
Mysql use tmpdir,
when ever there is any index creation.
regards
anandkl
On 8/21/08, jthorpe [EMAIL PROTECTED] wrote:
Hi,
I've been trying to import a 10G dump file using mysqlimport
and it is eventually failing because it runs out of tmpdir
space -- I get Errcode: 28.
I was surprised
You should increase parameter named max_bulk_insert_buffer_size and
max_allowed_packet.
On 8/21/08, Ananda Kumar [EMAIL PROTECTED] wrote:
Mysql use tmpdir,
when ever there is any index creation.
regards
anandkl
On 8/21/08, jthorpe [EMAIL PROTECTED] wrote:
Hi,
I've been trying to
Hi,
I would like to know if I can use the Load data infile to update a table on the
server from a workstation?
I tried it but was unsuccessful. Is there any other way to do this from a
workstation?
Thanks.
Regards,
Velen
data infile
Hi,
I would like to know if I can use the Load data infile to update a table on the
server from a workstation?
I tried it but was unsuccessful. Is there any other way to do this from a
workstation?
Thanks.
Regards,
Velen
--
MySQL General Mailing List
For list archives: http
i read about mysqlimport load data infile for mysql, but i can't find a
way to import text file using length of column, instead of delimiter
my text file contains fixed length column:
--
i can use ms excel to convert all files to .csv format and import, but it
would
hi all,
right now i'm trying to migrate from db2 running under linux to mysql v5.1.
i manage to export out the db2 structure data into a del (ascii) file.
but when i try to load the data from the del file to mysql table, it
generate an error.
below is the load data infile syntax i use =
LOAD
.
Dusan
Caleb Racey napsal(a):
Does anyone know how to get the load data infile command to load utf8
data?
I have setup a database as utf8 with a collation of utf8_general_ci,
the
mysqld server is started with --character-set-server=utf8. Server
variables
say character_set_database = utf8
Are you sure your file is coded in utf8? Character set of your file must
be same as charset of your database.
Dusan
Caleb Racey napsal(a):
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci
Ananda Kumar wrote:
Hi,
Try this.
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
Rather:
set session collation_database=utf8_general_ci;
set session character_set_database=utf8;
Also, make sure you have these in my.cnf:
[client]
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql below
LOAD DATA
Caleb Racey wrote:
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql
Caleb Racey wrote:
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql
Caleb Racey wrote:
On 10/26/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Caleb Racey wrote:
It is indeed buggy and badly documented. It depends on the current
database's character set instead. Try this:
SET NAMES utf8;
SET character_set_database=utf8;
LOAD DATA INFILE...
Baron
Thanks
Hi Friend,
Today I was testing the command 'Load data infile ...' command (
http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html ) in my system.
That time I was surprised when I put select statement in that table. The
scenario as follows :
In a text file which is to be loaded, I am having
At 01:08 PM 6/27/2007, you wrote:
Hi,
I have a question on LOAD DATA INFILE command.
I have a table with 10 columns. Is it possible to update only few
columns of this table using LOAD DATA INFILE?
No. As you found out Load Data loads the specified columns and sets the
other columns
6/27/2007, you wrote:
Hi,
I have a question on LOAD DATA INFILE command.
I have a table with 10 columns. Is it possible to update only few
columns of this table using LOAD DATA INFILE?
No. As you found out Load Data loads the specified columns and sets the
other columns to NULL. The only way
All,
I am loading data into mysql database using LOAD DATA INFILE. After the
load i am getting this error.
Warning | 1366 | Incorrect string value: '\xE9cor' for column
'CATEGORY_NAME' at row 2137 .
My database character set is as below
character_set_database | utf8
character_set_client
Hi All,
I am loading data into mysql database using LOAD DATA INFILE. After the load
i am getting this error.
Warning | 1366 | Incorrect string value: '\xE9cor' for column
'CATEGORY_NAME' at row 2137 .
My database character set is as below
character_set_database | utf8
character_set_client
Also friends,
When i see this data in the vi editor it looks like this Other Home DÃ(c)cor
Just wanted to give information. Please help me.
regards
anandkl
On 5/19/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I am loading data into mysql database using LOAD DATA INFILE. After the
load
I've just performed a LOAD DATA INFILE on the master server, and I've waited
a while now, and the data has not shown up in the SLAVE. Does Replication
not handle LOAD DATA INFILE?
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
During Replication the SLAVE reads data from its MASTER's log. Chances
are LOAD DATA gets no logging -- I won't be surprised.
-Original Message-
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: Friday, February 02, 2007 9:44 AM
To: MySQL List
Subject: Replication LOAD DATA INFILE
I've just
At 21:39 -0400 10/14/06, Ferindo Middleton wrote:
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date
Subject: change format of date fields during LOAD DATA INFILE?
Is there a way to change the format of date fields MySQL is
expecting when
LOADing data from a file? I have no problem with the format
MySQL saves the
date but most spreadsheet programs I use don't make it easy
to export text
-Original Message-
From: Ferindo Middleton [mailto:[EMAIL PROTECTED] ]
Sent: Saturday, October 14, 2006 9:40 PM
To: mysql
Subject: change format of date fields during LOAD DATA INFILE?
Is there a way to change the format of date fields MySQL is
expecting when
LOADing data from a file
At 08:39 PM 10/14/2006, Ferindo Middleton wrote:
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date fields in the format -MM-DD even if I formated the
to prevent mysql
from having to jump around as much.
What I have is a raw data file that I pre-process to create 3 separate
tab delimited files, which are then loaded into mysql using load data
infile...
I am working with a table with a primary key consisting of 2 fields.
| cdr_seq_no
updating
indexes. Overall it can be faster. From
http://dev.mysql.com/doc/refman/5.0/en/load-data.html :
If you use LOAD DATA INFILE on an empty MyISAM table, all non-unique
indexes are created in a separate batch (as for REPAIR TABLE).
Normally, this makes LOAD DATA INFILE much faster when you
:40 PM
To: George Law
Cc: MYSQL General List
Subject: Re: sorting datafile for load data infile
George, I've not heard of that technique - sorting so that mysql
doesn't have to jump around as much.
What I am aware of, and what can make a difference, is disabling
indexes prior to starting the load
George, for raw speed into a MyISAM table, I think you'll find it hard
to beat LOAD DATA INFILE, especially if you disable keys before and
re-enable afterwards (which is not unlike what your friend proposes -
creating the index in a more efficient fashion). I'd be interested to
hear how you get
am eager to see if this sorting idea helps any.
--
George
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Friday, August 18, 2006 3:53 PM
To: George Law
Cc: MYSQL General List
Subject: Re: sorting datafile for load data infile
George, for raw speed into a MyISAM
Mark Nienberg wrote:
I'm trying to use LOAD DATA INFILE to read a csv formatted file into a
mysql 5.0.22 table. Some of the fields contain text that has newline
characters in it. After reading the manual to learn how special
characters are treated, I altered the csv file so newlines
Gerald L. Clark wrote:
Mark Nienberg wrote:
I'm trying to use LOAD DATA INFILE to read a csv formatted file into a
mysql 5.0.22 table. Some of the fields contain text that has newline
characters in it. After reading the manual to learn how special
characters are treated, I altered the csv
I'm trying to use LOAD DATA INFILE to read a csv formatted file into a mysql 5.0.22
table. Some of the fields contain text that has newline characters in it. After
reading the manual to learn how special characters are treated, I altered the csv
file so newlines are represented by '\\n
has been updating the table's
index for the past several hours as part of the Load Data Infile process.
Is there any way to speed this up? I'm using MySIAM tables in v4.1.10.
Here are the settings I'm using. Is there anything in there that will
speed up the re-indexing?
TIA
Mike
Hi Mike,
Try the following:
ALTER TABLE tblname DISABLE KEYS;
LOAD DATA INFILE ...
ALTER TABLE tblname ENABLE KEYS;
hth, Cor
- Original Message -
From: mos [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, July 29, 2006 4:50 AM
Subject: Re: Way too slow Load Data Infile
At 03:56 AM 7/29/2006, C.R.Vegelin wrote:
Hi Mike,
Try the following:
ALTER TABLE tblname DISABLE KEYS;
LOAD DATA INFILE ...
ALTER TABLE tblname ENABLE KEYS;
hth, Cor
Hi,
I had tried that on another (larger) t year, and it does of course
load the data slightly faster because
I executed a Load Data Infile 24 hours ago and its still running. Yikes!
I have 6 of these tables to load and at this rate it will take forever. Can
someone please run through my Status variables and let me know if there is
a way I can optimize it? (These values are current with the Load Data
I ran a file monitor and it appears MySQL has been updating the table's
index for the past several hours as part of the Load Data Infile process.
Is there any way to speed this up? I'm using MySIAM tables in v4.1.10. Here
are the settings I'm using. Is there anything in there that will speed up
I'm replacing 14 million rows of data using Load data infile replace and
it is taking forever to complete. I killed it after 6.2 hours on an AMD
3500 machine. I then deleted all the data from the table and used Load
data infile ignore and it completed quite quickly in about 30 minutes
Hi Julie,
If you notice after your import, you have 3 warnings. This intrigued
me, so I created a test case (also running 5.0.18 standard):
create table bit_test (b bit(8));
cat /tmp/bit_test.txt
01010101
2
b'010'
b\'010\'
0x2
02
mysql load data infile '/tmp/bit_test.txt
Sheeri,
Wow. That was my first forum email and I thought it would go unnoticed. I
sure was wrong.
You are exactly right, because apparently with LOAD DATA INFILE, everything
in the file is treated as a string. I'm using PHP to create the text file,
so I tried PHP's pack() function to write
Hi. I'm using MySQL 5.0.18, and I'm trying to use LOAD DATA INFILE into tables
that have BIT(8) columns. No matter
what format I use, the result is not what I expect (see example below.) Anyone
know how to properly format the data for loading into a BIT column? Thanks!
$ cat /tmp/bit_test.txt
I'm creating a file via PHP after getting information from a log file. I
create a new file for data import into a table in MySQL. For some reason now
I'm getting this error below. I have no clue what it means. I've checked the
file and it is all there and I've even changed the permissions
execute what it needed. So if you run into this
simply check each directory within the path and make sure of it's
settings
-Original Message-
From: Jay Paulson (CE CEN) [mailto:[EMAIL PROTECTED]
Sent: Wed 1/11/2006 11:17 AM
To: mysql@lists.mysql.com
Subject: LOAD DATA INFILE
I'm
Do chmod -R 755 on datapath
Thanks
Praj
- Original Message -
From: Jay Paulson (CE CEN) [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, January 11, 2006 10:47 PM
Subject: LOAD DATA INFILE
I'm creating a file via PHP after getting information from a log file. I
create
78682 áDELL á TX áEastern
Operations
á áá
Is there any way I can set the FIELD TERMINATOR and LINE TERMINATOR to
include this character so my LOAD DATA INFILE works?
I tried using a variable and mysql didn't like it:
set @field:=concat(' ',char(160),'\t');
set
] wrote:
List: MySQL General Discussion« Previous MessageNext Message »
From: George Law Date: January 6 2006 11:01pm
Subject: Sorry for my n00bie question - mysql 5.0.18 with load data
infile
Get Plain Text
Hi All,
Just wanted to apologize for my earlier rambling
fields that get updated at a later
time.
There seemed to be a lot of processes out there waiting on table locks
when this was a myisam table.
The performance of the 'load data infile' command seems like it is
taking way too long.
(dates are just from `date` in perl):
2006-01-06 16:35:21 : begin
Hi mysql-list,
I just installed,
++
| version() |
++
| 5.0.16-log |
++
Here is what I am testing out: (simple table and data)
% echo 'a b c d' testfile
mysql CREATE TABLE `test` (
- `fe` VARCHAR( 2 ),
- `fi` VARCHAR( 2 ),
- `fo` VARCHAR( 2 ),
To: mysql@lists.mysql.com
Subject: LOAD DATA INFILE Syntax
Hi mysql-list,
I just installed,
++
| version() |
++
| 5.0.16-log |
++
Here is what I am testing out: (simple table and data)
% echo 'a b c d' testfile
mysql CREATE TABLE `test` (
- `fe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Arno Coetzee wrote:
Test USER wrote:
Can't get this to work, but i would like to specify LOAD DATA to use
an INFILE from an URL.
For example
LOAD DATA LOCAL INFILE 'http://www.testserver.com/data.csv' But i get
an error message saying file
Can't get this to work, but i would like to specify LOAD DATA to use an INFILE
from an URL.
For example
LOAD DATA LOCAL INFILE 'http://www.testserver.com/data.csv'
But i get an error message saying file not found.
Anyone know if this is even possible ?
?
-
Sent from my NYPL BlackBerry Handheld.
- Original Message -
From: Test USER [EMAIL PROTECTED]
Sent: 12/01/2005 04:55 AM
To: mysql@lists.mysql.com
Subject: LOAD DATA INFILE (url)
Can't get this to work, but i would like to specify LOAD DATA to use an INFILE
from an URL.
For example
LOAD DATA
Subject: LOAD DATA INFILE (url)
Can't get this to work, but i would like to specify LOAD DATA to use an
INFILE
from an URL.
For example
LOAD DATA LOCAL INFILE 'http://www.testserver.com/data.csv'
But i get an error message saying file not found.
Anyone know if this is even possible
Test USER wrote:
Can't get this to work, but i would like to specify LOAD DATA to use an INFILE
from an URL.
For example
LOAD DATA LOCAL INFILE 'http://www.testserver.com/data.csv'
But i get an error message saying file not found.
Anyone know if this is even possible ?
. The
table has around 25 million rows and usually only 1% of the table needs to
be compared.
I've found 2 ways to update the table with the new values:
1) I could write the new values to a text file and then use Load Data
InFile REPLACE ... which will replace the existing rows for the rows that
need
- Original Message -
From: mos [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, November 19, 2005 8:16 PM
Subject: Is Load Data Infile or Update is faster?
I am doing a balance line comparison between the rows of an existing table
and a text file that has newer data
At 11:15 PM 11/19/2005, Rhino wrote:
- Original Message - From: mos [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, November 19, 2005 8:16 PM
Subject: Is Load Data Infile or Update is faster?
I am doing a balance line comparison between the rows of an existing
table
Gleb Paharenko wrote:
Hello.
Are you sure that you want to load PDF with LOAD DATA INFILE?
Well, I had been sure, but not so much anymore. s
Maybe LOAD_FILE is that you want:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
Yup, this was the ticket. I'd seen several
Hello.
Are you sure that you want to load PDF with LOAD DATA INFILE?
Maybe LOAD_FILE is that you want:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
Whil Hentzen wrote:
Hi folks,
I want to load a set of PDFs into a MySQL 5 ISAM table. I'm using the
following
Hi folks,
I want to load a set of PDFs into a MySQL 5 ISAM table. I'm using the
following command
LOAD DATA INFILE '1037021.pdf' INTO TABLE complete FIELDS TERMINATED BY
'%%EOF' (d_c)
in the Query Browser 1.1.17, MySQL 5.0.15, running on W2K. Field d_c is
defined as LONGTEXT
Why cant i get this to work? The name dont get replaced... :P
LOAD DATA
LOCAL
INFILE '/tmp/myfile.txt'
INTO TABLE cache
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(name)
SET name = REPLACE(name, 'Coke', 'Pepsi');
-
FREE
At 23:46 +0100 11/2/05, John thegimper wrote:
Why cant i get this to work? The name dont get replaced... :P
LOAD DATA
LOCAL
INFILE '/tmp/myfile.txt'
INTO TABLE cache
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(name)
SET name = REPLACE(name, 'Coke', 'Pepsi');
Please file
'Yemi Obembe wrote:
i'm having a problem with the load data infile command...i'm actually running
the script from a php script that goes this way:
?php
mysql_connect(localhost, $user, $pass);
mysql_select_db(ng);
$sql = load data local infile 'movies.txt' into table dir fields terminated
i'm having a problem with the load data infile command...i'm actually running
the script from a php script that goes this way:
?php
mysql_connect(localhost, $user, $pass);
mysql_select_db(ng);
$sql = load data local infile 'movies.txt' into table dir fields terminated by
'|';
if($res
i'm having a problem with the load data infile command...i'm actually running
the script from a php script that goes this way:
?php
mysql_connect(localhost, $user, $pass);
mysql_select_db(ng);
$sql = load data local infile 'movies.txt' into table dir fields terminated by
'|';
if($res
parses scripts and such.
-Sheeri
On 10/20/05, 'Yemi Obembe [EMAIL PROTECTED] wrote:
i'm having a problem with the load data infile command...i'm actually running
the script from a php script that goes this way:
?php
mysql_connect(localhost, $user, $pass);
mysql_select_db(ng);
$sql = load data
Dear Michael,
thank you for your response.
If a duplicate unique key is found when importing with LOAD DATA INFILE,
How does that happen? I take it you are adding the imported data into an
already populated table.
True, that's what I meant to say.
Don't alter the keys for the existing
Hello,
I use tables with one primary key (which is the only unique key). I'd like
to export data from such a table to a file, and then import it on another
machine.
If a duplicate unique key is found when importing with LOAD DATA INFILE,
MySQL gives me the choice of whether to
1. stop
Gerhard Prilmeier wrote:
Hello,
I use tables with one primary key (which is the only unique key). I'd
like to export data from such a table to a file, and then import it on
another machine.
If a duplicate unique key is found when importing with LOAD DATA INFILE,
How does that happen? I
I am attempting to import a large file with data in this format:
1923158|GA|1996 Olympic Yachting
Cauldron|park|Chatham|13|051 |320446N|0810502W|32.07944|-
81.08389Savannah
With this command:
LOAD DATA LOCAL INFILE 'C:\\PHP\\FL_DECI.txt'
INTO TABLE locations2
FIELDS TERMINATED BY '|'
http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
Bob Cochran
Jason Ferguson wrote:
I am attempting to import a large file with data in this format:
1923158|GA|1996 Olympic Yachting
Cauldron|park|Chatham|13|051 |320446N|0810502W|32.07944|-
81.08389Savannah
With this
Robert L Cochran wrote:
http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
There's a lot to read there for one small paragraph, so from the above link:
Before MySQL 5.0.3, the column list must contain only names of columns
in the table being loaded, and the SET clause is not
I've been over that page before posting, with no luck. It might be an
obvious error in syntax, but I can't figure it out.
Jason
On 9/26/05, Robert L Cochran [EMAIL PROTECTED] wrote:
http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
Bob Cochran
Jason Ferguson wrote:
I am
Okay, now I get it. I was using the 4.1 series. Looks like an upgrade is in
order.
Jason
On 9/26/05, Jasper Bryant-Greene [EMAIL PROTECTED] wrote:
Robert L Cochran wrote:
http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
There's a lot to read there for one small paragraph, so from
Hi,
i am trying to load a csv file with LOAD DATA INFILE. This File
contains columns with decimal values with the german comma instead of
the dot as separator (e.g. 3.20 is 3,20). Is there an option to handle
this during or immediately before LOAD with MySQL Commands/Tools. Now we
only see values
Hi,
i am trying to load a csv file with LOAD DATA INFILE. This File
contains columns with decimal values with the german comma instead of
the dot as separator (e.g. 3.20 is 3,20). Is there an option to handle
this during or immediately before LOAD with MySQL Commands/Tools. Now we
only see values
1 - 100 of 499 matches
Mail list logo
