Published on BLACK HILL SYSTEMS (http://blackhillsystems.com)

Home > Split MySQL Dump File into multiple files

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

Source URL: http://blackhillsystems.com/?q=node/39