Rename MySQL database from bash

You can use a following command to rename databases in bash.

mysql -u USER -pPASSWORD OLDDB -sNe 'show tables' | while read table; do mysql -u USER -pPASSWORD NEWDB -sNe "RENAME TABLE \`OLDDB\`.$table TO \`NEWDB\`.$table"; done