[MySQL] Import a large (14 GB) MySQL dump file into a new MySQL database

import_large_dump_file.md

mysql --u root --p

SET global
net_buffer_length=1000000; --Set network buffer length to a large byte number

SET global
max_allowed_packet=1000000000; --Set maximum allowed packet size to a large byte number

SET foreign_key_checks=0; --Disable foreign key checking to avoid delays, errors and unwanted behaviour

source file.sql --Import your sql dump file

SET foreign_key_checks=1; --Remember to enable foreign key checks when procedure is complete!