How to import csv file into mysql by phpmyadmin


Problem :

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



Solution :

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)

Mysql Tutorials

Mysql Howto..

How to disable dynamic select box options based on data coming from two tables in mysql database

How to delete all the tables in a MySQL database? [duplicate]

How to update mysql column with another value from another table?

Show the price in a textbox after selecting the id from a selected menu

How to return different strings from a Boolean type in MySQL?

How to set column's comment with CREATE TABLE and SELECT statement

How can I query for text containing Asian-language characters in MySQL?

How to apply a ranking algorithm using PHP/MySQL? [closed]

MySQL Transaction - How to group?

How to convert time in seconds to HH:MM:SS format in MySQL?

how to get rid of network error(TCP_ERROR) in BIRT?

How to allow Mysql to add more than 1000 rows?

MySQL - How to normalize column containing delimiter-separated IDs

For MySQLDump, add a comment which outputs how many rows were dumped for each table

How to execute SELECT and INSERT in single query with PHP/MYSQL?

how to install multiple tables to a mysql database with php pdo

Neo4j - How to emulate MySQL multiple schema deployment in Neo4j

How to get last 12 digits from a string in MySQL?

How can I add conditions in my sql request?

How to update file path with \\ in mysql using java?

MySQL: How to SUM() a TIMEDIFF() on a group?

How to submit concurrent MYSQL queries (SELECT queries) at an instance? [closed]

How can I load data from file within .jar to Mysql table?

How to migrate data between MySQL bases on different servers?

How to sort table ascending and descending by click state? MYSQL/ColdFusion

How to insert DateTime object using Odbc?

How to insert HTML entities in MySQL using CodeIgniter?

How to group mysql rows with same column value into one row?

How to avoid table duplication in MySQL

In a MySQL Trigger, how to get informations on the user sending the request?