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, see ...
... for how to tweak imoorts of
the Artful MySQL Tips page