Split MySQL dumps

mySplitDump.sh

file=$1

nextDB=""
nextStart=0
nextEnd=0
lastDB=""
lastStart=0

for i in `grep -n "^CREATE DATABASE" $file | awk '{print $1":"$7}' | sed "s/CREATE://g"`
do

  i=`echo $i | sed "s/\\\`//g"`
  nextDB=`echo $i | cut -d : -f 2`
  nextStart=`echo $i | cut -d : -f 1`
  nextEnd=$(( $nextStart -1 ))

  if [ "$lastDB" == "" ]
  then
    header=`sed -n 1,${nextEnd}p $file`
  else
    echo "$lastDB from $lastStart to $nextEnd"
    echo "$header" > _$lastDB.sql
    sed -n ${lastStart},${nextEnd}p $file >> _$lastDB.sql
  fi

  lastDB=$nextDB
  lastStart=$(( $nextStart ))

done

echo "$lastDB from $lastStart"
echo "$header" > _$lastDB.sql
sed -n ${lastStart},\$p $file >> _$lastDB.sql

An alteration of http://lists.mysql.com/mysql/226821