I used to do this with the BSD split(1) utility back in the day. (8+ years ago) I ran a BSD only shop back then but now I have GNU split(1) and it lacks the -p argument for pattern.<p>Either way, my Macintosh still has BSD split(1) so here's a command example.<p><pre><code> split -p 'Table structure for table `' my_dump-20130913.sql</code></pre>