Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
#!/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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment