Rename a MySQL database

renamedb.sh

#!/bin/bash

# Disclaimer - make backups, use at your own risk.
#
# Based on this comment: http://stackoverflow.com/a/13944924/843067
# Views and stored procedures have to be done separately.

OLDDB="thunder"
NEWDB="phpedu"
MYSQL="mysql -u root -p "

$MYSQL -e "CREATE DATABASE \`$NEWDB\`;"

for table in `$MYSQL -B -N -e "SHOW TABLES" $OLDDB`
do 
  $MYSQL -e "RENAME TABLE \`$OLDDB\`.\`$table\` to \`$NEWDB\`.\`$table\`"
done

# You *might not* want to uncoment line below since
# in case of problems while renaming tables
# you will lose all database

mysql -e "DROP DATABASE \`$OLDDB\`;"

echo "Database renamed successfully"