![]() ![]() Need to make MySQLs LOAD DATA LOCAL INFILE load large data faster. But both your approaches are what I was looking for. load data local infile C:tempabc.csv into table tablename fields terminated by, ignore 1 lines. I guess (as Greg said) you have a bit more power of the raw data from a temp table. Took just over 10 hours from a t2-medium EC2 to db.t2. mysql> LOAD DATA LOCAL INFILE processed.csv mysql> INTO TABLE table mysql> FIELDS TERMINATED BY mysql> IGNORE 1 LINES Thanks Kevin This should work as well.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |