Split MySQL Dump File into multiple files

published by admin on Sat, 04/11/2015 - 20:24

awk '/CREATE TABLE/{f=0 ;n++; print >(file="out_" n); close("out_" n-1)} f{ print > file}; /CREATE TABLE/{f=1}' sql_file