Data Export and Import

[Jim Sawyer]

I have a table, "Records" which currently has about 3.8M records. It has 55 fields, the largest a varchar(80) with a lot of floats and booleans. It has 10 indexes including the primary. I export it with the statement

mysqldump -uroot -p1Dmin! AmeriData Records > C:\Users\XS\Documents\Dumps\AmeriData_Records;

I import it (if necessary) with the following:

set global net_buffer_length = 1000000;
set global max_allowed_packet = 1000000000;
set foreign_key_checks = 0;
alter table Records DISABLE KEYS;
source C:\Users\Spyke\Documents\Dumps\Mellina\ameridata_records.sql
alter table Records ENABLE KEYS;
set foreign_key_checks = 1;

It takes about 10 hours to import one table. Does anyone have any suggestions how I could shorten the import time?

Thanks,
Jim Sawyer