How to import (very) large data in mysql (w/o phpmyadmin)

Tweet

/** How to import very large data in mysql tables, from CSV 
windows : run mysql -> cmd -> c:/wamp/bin/mysql/mysql5.5.8/bin/mysql
copy the csv file to the folder (or use absolute path to it)*/

load data local infile 'mails.csv' into table database_name.table_name fields terminated by ','
//you can add : enclosed by '"'
; /* when you type semicolon the command will be send (NOT at enter)
You`ll get a resulit like 
Query OK, 71922 rows affected, 65535 warnings (10.95 sec)
Records: 73148  Deleted: 0  Skipped: 1226  Warnings: 73186

Thats it
use your saved time to visit btools.eu

when phpmyadmin gets timed out, mysql imported 50mb of raw data in 8sec */

Comments (Your Comments)