[SOLVED: mysqldump + mysql < is much faster than LOAD DATA INFILE. 56 mins vs 30hrs]
What steps would you suggest in order to bulk load a fairly large table? (115M+ rows; 8G+ footprint)
- ex1: start with a myIsam engine, disable keys, load infile, enable keys, alter engine to innoDB
- ex2: mysqldump locally, zip and upload to PA, mysql <
- ex3. create the innodb on PA, make a copy of the local table.idb, zip and upload, ask PA staff to copy to the proper directory. issue ALTER TABLE tbl_name IMPORT TABLESPACE
A naive LOAD DATA INFILE on PA takes a day to run. Locally, it completes in an hour