Renomeie rapidamente um banco de dados MySQL

mysql -u username -ppassword old_db -sNe 'show tables' | while read table;  

    do mysql -u username -ppassword -sNe "rename table old_db.$table to new_db.$table"; done

for table in `mysql -u root -ppassword -s -N -e "use old_db;show tables from old_db;"`; do mysql -u root -ppassword -s -N -e "use old_db;rename table old_db.$table to new_db.$table;"; done;

mysqldump -u username -p -v olddatabase > olddbdump.sql

mysqladmin -u username -p create newdatabase

mysql -u username -p newdatabase < olddbdump.sql

mysqladmin -u username -p create newdatabase

mysqldump -u username -v olddatabase -p | mysql -u username -p -D newdatabase