I've been waiting now for 36 hours for a 12 GB .sql file to be imported with a simple
type site.sql | mysql command. I can see the
ibdata1 is growing still, currently nearly 40 GB.
Considering the triggers and stored procedures are at the end of the .sql, I only think MySQL should be adding data and key indexes.
The site.sql was generated using this command from another server:
mysqldump -R -e --databases site --add-drop-database --add-create-database --add-drop-table -C --single-transaction --triggers
What's taking so long?
LOAD DATA INFILE. Also, as you're moving a whole database, see my answer re: moving databases between servers if you're staying within the same major version. (especially if you have to abort & restart)