9dbuk1Bp

1#!/bin/bash
2echo "Informe a base de dados antiga:";
3read -r old_db
4echo "Informe a base de dados nova:";
5read -r new_db
6script_file="rename-${old_db}-${new_db}.sql"
7
8truncate -s 0 $script_file
9
10echo "SET FOREIGN_KEY_CHECKS = 0;" >> $script_file;
11echo "CREATE DATABASE IF NOT EXISTS $new_db;" >> $script_file;
12
13for table in `mysql -s -N -e "use $old_db;show tables from $old_db;"`;
14do
15        echo "rename table $old_db.$table to $new_db.$table;" >> $script_file;
16done;
17
18echo "SET FOREIGN_KEY_CHECKS = 1;" >> $script_file;