Q:

How to import csv file into mysql by phpmyadmin

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

A:

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)

