Question :
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
totable_legacy
-
rename
table_new
totable
4.add index or constaint if needed
is it possible or what is the best way to complete this task?
Answer :
Maybe this blog can help you about how to quickly restore MySQL logical backups.Click here