How to speed up a loading data into MySQL from a zipped archive
Please keep in mind the behavior a mysqldump


It dumps all databases in alphabetical order
It dumps all tables in each database in alphabetical order
It loads each tables like this

Drops the table
Creates the Table
Table is Loaded

Disables Keys
Locks the Table for Writes
Multiple Exteneded INSERTs
Unlock the Table
Enable Keys

When the keys of table are disabled, only PRIMARY KEYs and UNIQUE KEYs are reloaded. When keys are enabled, then all non-unique keys are built linearly.



I would recommend you add this to /etc/my.cnf setting bulk_insert_buffer_size as follows

[mysqld]
bulk_insert_buffer_size=256M
key_buffer_size=1G


because the default is 8M. You do not need to restart mysql. Just run this SQL command

SET GLOBAL bulk_insert_buffer_size = 1024 * 1024 * 256;


Give it a Try !!!