====== Split a File Using Awk ======
I needed to split a large file (in this case a mysql dump of all databases combined) into individual files each consisting of the SQL statements related to that DB.  [Remember COBOL batch processing?]

Each section of the mysql database starts with:

<code>
-- Current Database: `mysql`
</code>
<code>
awk -F'`' '{if ($0 ~ /^-- Current Database:/) db=$2; print &gt;&gt; db&quot;-20110301.sql&quot;}' mysql-full-Tuesday.sql
</code>