Tips for speeding up dump and import data in MySQL
Importing large SQL datasets into MySQL can take a long time. These tips speed it up by adjusting indexes, inserts, autocommit, and constraint checks.
EXPLORE THE TOPIC
Import database.
2 articles on this topic
How to streaming export and import MySQL database to other server
You can dump a database and simultaneously import it on another machine by using nc (netcat) to stream data to the destination.