MySQL. How to speed up the import of a large dump (40GB)?

Question

MySQL

Good afternoon.
Are there any ways to speed up the import of a large dump somehow? The dump weighs 40GB
Thanks in advance!

Answer 1

ssd and normal percent
Well, of course, download via the console
mysql -uUSER -p database <dump.sql
You can of course tweak the configs, but it already depends on the database and what data to tweak. I'm not sure that will give a significant increase.

Answer 2

mysqldump -uroot DB | mysql --host=host -uroot -ppass -C DB

https://toster.ru/answer?answer_id=1223214#answers...