wardbekker

# 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 "<"