importing a large txt file in MySQL ?
- by Taz
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