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: 318

Filed under:
|

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

Related posts about mysql

Related posts about database