How to import csv file into mysql by phpmyadmin

Question

I am importing Geolite city database in csv format into my phpmyadmin but it only imports first line of it and then saying the "web page not available".

have you tried doing this directly on mysql console?

user745235
– user745235

2012-10-17 14:49:10 +00:00
Commented Oct 17, 2012 at 14:49 — user745235
– user745235, Commented Oct 17, 2012 at 14:49

Anshu · Accepted Answer · 2012-10-17 14:57:14Z

2

You can directly load the CSV in mysql using following command:

load data local infile 'csvFileName.csv' into table tblUniq fields terminated by ','
enclosed by '"' lines terminated by '\n' (field1, field2, field3)

answered Oct 17, 2012 at 14:57

Anshu

7,8635 gold badges33 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Anshu Over a year ago

There is no need to mention thanks, you can show your gratitude on SO by voting up and accepting the answer :)

Collectives™ on Stack Overflow

How to import csv file into mysql by phpmyadmin

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related