By 08/02/2016 0 Comments

Quickly rename a MySQL database schema?

  • For InnoDB, create the new empty database, then rename each table in turn into the new database.


RENAME TABLE old_db.table TO new_db.table;

  • After above code write the following code for permission.


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

Posted in: Solutions

Leave your valuable Comment

Have a natural attraction for women cosmetics and replica watches uk clothes, no
more than two for men the most attractive one, is to make their own driving experience, happy and can serve as the facade of the car, another is to highlight the taste edify sentiment rolex replica watch. The replica rolex is undoubtedly the most fashionable accessories, wear a suit to attend the activities, but also get a decent match on the replica watches .