Created
March 16, 2015 17:31
-
-
Save bgadrian/5b462c30eca016b8a6dd to your computer and use it in GitHub Desktop.
Import (very) large data in mysql (w/o phpmyadmin)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** 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 */ |
how to get btools in free
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
hello