what is the fastest way to import data into mysql 5.7

Posted on

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:

  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?

Answer :

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

Leave a Reply

Your email address will not be published. Required fields are marked *