...
- Create the table properly (with index)
- Flush table
No Format $ mysqladmin flush-tables -u bing -p
- Removes all use of indexes for the table
No Format $ sudo myisamchk --keys-used=0 -rq /var/lib/mysql/dbName/tblName
- LOAD DATA INFILE.Adjust the parameters corresponding to your csv file.
Adjust the parameters corresponding to your csv fileNo Format $ mysql -u your_user_name -p mysql> use your_db_name; mysql> LOAD DATA INFILE 'your_data_file.csv' INTO TABLE `your_tbl_name` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES;
- Re-create the indexes
No Format $ sudo myisamchk --key_buffer_size=1024M --sort_buffer_size=1024M -rq /var/lib/mysql/dbName/tblName
- Flush table
No Format $ mysqladmin flush-tables -u bing -p
...