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 ...

http://dba.stackexchange.com/questions/13446/slow-load-speed-of-data-from-mysqldump

https://www.percona.com/blog/2018/02/22/restore-mysql-logical-backup-maximum-speed/

... for how to tweak imoorts of mysqldump backups.



Return to the Artful MySQL Tips page