MySQL Forums
Forum List  »  Backup

Data Export and Import
Posted by: Jim Sawyer
Date: July 27, 2021 07:58AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Data Export and Import
303
July 27, 2021 07:58AM
171
July 27, 2021 09:26AM
162
July 27, 2021 11:03AM
144
July 27, 2021 01:12PM


Sorry, only registered users may post in this forum.

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.