jasny/mysql-rename-db.sh

## mysql-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
	#!/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