Simple script to move all tables from one database to another. Please don't use this in product as could fail horribly. Also, RENAME table doesn't work on views, so they won't be migrated.

rename-db.sh

#!/bin/sh

OLD_DB=$1
NEW_DB=$2

TABLES=`echo "SHOW TABLES IN $1;" | mysql -NB`

IFS="
"

for TABLE in $TABLES; do
    $(echo "RENAME TABLE \`$1\`.\`$TABLE\` TO \`$2\`.\`$TABLE\`;" | mysql)
done