Speed up dump import
from the Artful MySQL Tips List
The 5.7 manual says (
) "for large-scale backup and restore, a physical backup is more appropriate, to copy the data files in their original format that can be restored quickly", and recommends the MySQL Enterprise mysqlbackup utility.
If that's not feasible,
describes many tweaks for restoring from
the Artful MySQL Tips page