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".

Answer 1

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)