Import Large MySQL File

import-huge-sql.sh

# create prepend sql commands
echo "set autocommit=0;set unique_checks=0;set foreign_key_checks=0;" > prepend.sql

# prepend huge.sql above commands
cat huge.sql >> prepend.sql

# create append sql commands
echo "set autocommit=1;set unique_checks=1;set foreign_key_checks=1;" > append.sql

# prepend huge.sql with append.sql
cat append.sql >> huges.sql

# import to mysql database
mysql -uroot -p database_name < huge.sql