Extract CREATES from SQL dump
If you are trying to extract the create routines from a SQL dump, this might help you!
Basically it picks out the contents between “CREATE” and “\;”
You can modify these two variables as need be..
[bash]
cat dump.sql |awk ‘/CREATE/,/\;/ { print $0 ; }’ > create.sql
[/bash]
