If you need to import a very large SQL dump file to MySQL, the following should speed things up considerably:

At the begining of the SQL dump file, add:

SET autocommit=0;
SET unique_checks=0;
SET foreign_key_checks=0;

and at the end:

COMMIT;

Then proceed as usual with the import, i.e

mysql> source myfile.sql