0

I've got a huge excel file (~6GB) that I've had to split up into multiple files. Now I need to be able to take each file and upload it into a MySQL database so I can search through it. The format each row is displayed in is as follows:

6003393,"Walgreens","670 N Lake Ave","Pasadena","CA","91101-1220","Los Angeles","6265858926","","","","","","","20 to 49","2.5 to 5 million","591205","Pharmacies & Drug Stores"

How would I go about doing this efficiently with this much data?

Thank you.

Joshua Terrill
  • 1,995
  • 5
  • 21
  • 40
  • This appears to be very similiar to [3621798](http://stackoverflow.com/questions/3621798) or [8031193](http://stackoverflow.com/questions/8031193) – arober11 Dec 02 '12 at 23:13

1 Answers1

2

Look into the LOAD DATA INFILE syntax. As long as your CSV is well-formed, it should be able to load up all of it... eventually.

Marc B
  • 356,200
  • 43
  • 426
  • 500