mysql> LOAD DATA LOCAL INFILE '/tmp/HINODE_sizes.txt' REPLACE INTO TABLE hinode.files ( filepath, instrument, quicklook, mod_time, filesize ); Query OK, 11884251 rows affected, 1 warning (7 min 26.99 sec) Records: 6264061 Deleted: 5620190 Skipped: 0 Warnings: 1