MySQL fast data load

mysql_fast_load.sql

#1
LOAD DATA INFILE...

#2
ALTER TABLE name DISABLE KEYS; // tells MySQL to stop updating nonunique indexes
INSERT ...
...
ALTER TABLE name ENABLE KEYS; // re-creates missing indexes (much faster than inserting one by one)

#3 (InnoDB)
BEGIN;
INSERT ...
...
COMMIT;