Access to MySQL
You have to be root to set those settings
# mysql -u root -p
Maximize all Buffer and Packet
Set network buffer length to a large byte number and set maximum allowed packet size to a large byte number
set global net_buffer_length=1048576;
set global max_allowed_packet=1073741824;
SET foreign_key_checks = 0;
SET UNIQUE_CHECKS = 0;
SET AUTOCOMMIT = 0;
Import your SQL file
Import your sql dump file, you can import more than one file
source file-to-import.sql;
Set back to default
Remember to enable foreign key checks when procedure is complete!
SET foreign_key_checks = 1;
SET UNIQUE_CHECKS = 1;
SET AUTOCOMMIT = 1;