Transfer tables from one MySQL table to another

transfer_mysql.sh

#http://stackoverflow.com/questions/67093/how-do-i-quickly-rename-a-mysql-database-change-schema-name?page=1&tab=votes#tab-top
for table in `mysql -h $host -u root -P $port --password=$password -w -N -e "show tables from $schema"`; do 
mysql -h $host -u root -P $port --password=$password -w -N -e "rename table $schema.$table to $schema_two.$table"; 
done;