I do. So I’ve written small bash script to do so. I think it’s self explanatory and does it’s job well :)
#!/bin/bash
if [[ $# -lt 1 ]]; then
echo "Usage: $0 filename"
exit 1
fi
FILE=$1
echo "Spliting "$FILE""
# default filename for sql headers
dbname=header
cat $FILE | while read line; do
# echo $line
if [[ $line =~ ^USE\ \`([^\`]*)\`\; ]]; then
dbname=${BASH_REMATCH[1]}
echo "Found db '$dbname'"
fi
echo $line >> $dbname.sql
done
I do NOT have CREATE DATABASE in sql file, thus set to USE..