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:

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

  2. remame old table to table_legacy

  3. 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?

1 Answer 1


Maybe this blog can help you about how to quickly restore MySQL logical backups.Click here

  • Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference Commented Jun 20, 2020 at 13:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.