mrkeck Sharing the Love

14Jun/110

Import Large Files into MySQL phpmyadmin

Start by doing what this site says:

http://daipratt.co.uk/importing-large-files-into-mysql-with-phpmyadmin/

Note:  File extension must be lower case for it to be recognized

The trick to getting it to go much faster is using the CSV using LOAD DATA option on the left side

For the csv file I set the field delimiter(Fields terminated by) to | (vertical bar), no text delimeter(Fields enclosed by),Left Fields escaped by \, and row delimiter(Lines terminated by) to ;  By default it is set to auto, but if it doesn't get the rows right try \n

I used these settings because the data has commas in the contents and CR/LFs also.

It took 30secs to import 60,000 with indexes and 10min to import 2,000,000 with indexes

Filed under: mySQL Leave a comment
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

No trackbacks yet.