use test;
CREATE TABLE  IF NOT EXISTS ip20090101(
ip_time int(4) unsigned,
ip_in  varchar(18) NOT NULL,
ip_in_port int(4) unsigned,
ip_out varchar(18) NOT NULL,
ip_out_port integer,
ip_id char(6),
KEY ix_ip_in  (ip_in),
KEY ix_ip_out (ip_out),
KEY ix_ip_id  (ip_id)
             ) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=4000000000
/*!50100 PARTITION BY RANGE (ip_time)
(PARTITION p0 VALUES LESS THAN (1500) ENGINE = MyISAM,
 PARTITION p1 VALUES LESS THAN (1511) ENGINE = MyISAM,
 PARTITION p2 VALUES LESS THAN (1522) ENGINE = MyISAM,
 PARTITION p3 VALUES LESS THAN (1533) ENGINE = MyISAM) */
 ;
 
load data concurrent infile '/home/mysql/rez.txt' into table test.ip20090101 fields terminated by '#';