Naive parallel import of Compressed MYSQL dump file

gistfile1.bash

# Split MYSQL dump file

zcat dump.sql.gz | awk '/DROP TABLE IF EXISTS/{n++}{print >"out" n ".sql" }'

# Parallel import using GNU Parallel http://www.gnu.org/software/parallel/

ls -rS *.sql | parallel --joblog joblog.txt mysql -uXXX -pYYY db_name "<"

easy to do instructions:
#zcat dump.sql.gz | awk '/DROP TABLE IF EXISTS/{n++}{print >"out" n ".sql" }'
#command above splits your db into multiple files, so better create a folder , put your dump.sql.gz file(ie., rename to dump.sql and then compress to gz format, if you don't want/know editing above command!!!)

#ls -rS *.sql | parallel --joblog joblog.txt mysql -uXXX -pYYY db_name "<"
Running this command , imports all you tables using parallel. Create an empty database and Put database username and password and database name you just created in above command.