How to quickly import a large database?

Question

MySQL

I put import of basis for the night today.
Through the console with the command:
source dump.sql

And everything went with these query requests. But only 11 hours have already passed and it seems to be just finishing up, judging by the pages in phpMyAdmin, is there a faster option?
It's just that "Buy an ssd" yes, I know, but also?

Answer 1

in general, if from the bells and whistles, in addition to data, only indexes (not triggers / procedures that can be tied to the id of related tables), then the fastest way is to load from file (I don’t remember the command, LOAD DATA INFILE etc) and in the MyISAM table and then its envelope in InnoDB
, well, then hanging indexes and triggers, with an understanding of what and how and in what place
if it’s just a dump - look here - something can be tweaked:
https://dba.stackexchange.com/questions/83125/mysq...
again, just a dump minimizes manual involvement, unlike file and related issues with same encodings, field sizes Etc

Answer 2

if the mysql database is easier to do through the console, open the console and enter
mysql -v ,
the version of mysql should be displayed, if not, then it’s sad
if yes, then we continue (without quotes) All that remains for us is to study the messages in the console about the progress of the operations contained in the dump.