importing a large txt file in MySQL ?
Posted
by Taz
on Stack Overflow
See other posts from Stack Overflow
or by Taz
Published on 2010-04-09T06:20:28Z
Indexed on
2010/04/09
6:23 UTC
Read the original article
Hit count: 323
Hi I am loading a text data in MySQL using the following command
'mysql> Load Data local Infile 'C:\\Documents and Settings\\Scan\\My Documents\\D
ownloads\\instance_types_en.nt\\Copy of instance_types_en.txt' into table dbpedi
aentities.resources fields terminated by ' ' lines terminated by 'rn';'
Data is like (actually there is a newline after '.')
<a> <b> <c> .
<a> <b> <c> .
<a> <b> <c> .
<a> <b> <c> .<a> <b> <c> .
<a> <b> <c> .
Table has and auto increment ID field and then text fields for all three values.
File size is about 750MB
The problems are
1. appears to be in first text field
2. only 2MB data is imported
© Stack Overflow or respective owner