mysql> load data infile 'd:/tmp/b129_SNPMapInfo_36_3.bcp' into table t2; Query OK, 44627804 rows affected (3 min 2.86 sec) Records: 44627804 Deleted: 0 Skipped: 0 Warnings: 0 mysql> show table status; +------+--------+---------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +------+--------+---------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+ | t2 | MEMORY | 10 | Fixed | 44627804 | 105 | 5039014752 | 3534400124 | 6684444571 | 0 | NULL | 2013-02-04 08:05:58 | NULL | NULL | latin1_swedish_ci | NULL | | | +------+--------+---------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+ 1 row in set (0.00 sec) mysql> select version(); +-----------+ | version() | +-----------+ | 5.5.29 | +-----------+ 1 row in set (0.00 sec) mysql> ------------------------------- mysql> load data infile 'd:/tmp/b129_SNPMapInfo_36_3.bcp' into table t2; Query OK, 44627804 rows affected (2 min 58.39 sec) Records: 44627804 Deleted: 0 Skipped: 0 Warnings: 0 mysql> show table status; +------+--------+---------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +------+--------+---------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+ | t2 | MEMORY | 10 | Fixed | 44627804 | 105 | 5039014752 | 3534400124 | 6684444571 | 0 | NULL | NULL | NULL | NULL | latin1_swedish_ci | NULL | | | +------+--------+---------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+ 1 row in set (0.00 sec) mysql> select version(); +------------------+ | version() | +------------------+ | 5.1.57-community | +------------------+ 1 row in set (0.00 sec) mysql>