what is the fastest way to import data into mysql 5.7 Now I want to import a 10000000+ record table from database A mysql cluster to B mysql cluster,now I am using :
source xx.sql

It is so slow. Now what is the fastest way to import? I want to import like this:

import a new table,like table_new(it should be very fast like copy data,may be 1000000/s)

remame old table to table_legacy

rename table_new to table


4.add index or constaint if needed
is it possible or what is the best way to complete this task?
Maybe this blog can help you about how to quickly restore MySQL logical backups.Click here