How to import (very) large data in mysql (w/o phpmyadmin)
/** 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
use your saved time to visit btools.eu
when phpmyadmin gets timed out, mysql imported 50mb of raw data in 8sec */
No Responses to “How to import (very) large data in mysql (w/o phpmyadmin)”
Comments (Your Comments)