Data Export and Import
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
Subject
Views
Written By
Posted
Data Export and Import
812
July 27, 2021 07:58AM
610
July 27, 2021 09:26AM
470
July 27, 2021 11:03AM
511
July 27, 2021 01:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.