Speed up dump import

from the Artful MySQL Tips List

The 5.7 manual says (http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#mysqldump-performance) "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 mysqldump backups.

Last updated 16 Aug 2019

Return to the Artful MySQL Tips page