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?

Jim Sawyer

Options: ReplyQuote

Written By
Data Export and Import
July 27, 2021 07:58AM
July 27, 2021 09:26AM
July 27, 2021 11:03AM
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.