Do not create indexes before adding data.
A typical database dump consists of two sections:
1. database structure
2. database data
The database structure creates tables: their fields and indices.
You need to cut the code of these indexes and add the creation of the indexes to the end of the dump.
Then the speed of importing the dump will increase by 50 times.
The speed is also affected by the type of tables - myisam is faster than innodb.