split a single sql file into multiple files - UNIX for Dummies Questions & Answers - The UNIX and Linux Forums

The UNIX and Linux Forums

Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

		The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
split a single sql file into multiple files

.

google unix.com

Mark Forums Read

Thread: split a single sql file into multiple files

View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->

#4 (permalink)

Old

09-12-2008

rubin

rubin is offline

Forum Advisor

Registered User

Join Date: Nov 2007

Posts: 321

If the blank line between CREATE TABLE paragraphs is always present this should suffice:

Code:

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

Otherwise use,

Code:

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