These settings will dramatically increase
the import speed of innodb data from a mysqldump export file,
containing an Innodb table with millions++ of rows,
transforming what used to span hours into mere minutes,
Set, import, then reset my.cnf to original settings.
(restart required for each change)

In my.cnf set (my workstation has 8G RAM)

innodb_buffer_pool_size = 4G
innodb_log_buffer_size = 500M
innodb_log_file_size = 1G
innodb_write_io_threads = 16
innodb_flush_log_at_trx_commit = 0

In the mysqldump file add this before you start the sql statements

SET FOREIGN_KEY_CHECKS=0;
SET UNIQUE_CHECKS=0;
SET AUTOCOMMIT=0;

At the end of the file don't forget

COMMIT;

Aloha!