Quickly Rename MySQL Database

You can rename a MySQL database from the shell prompt using mysqldump command without storing the sql dump into a file:

mysql -u root -p'password' -e "create database newdb"
mysqldump -u root -p'password' originaldb | mysql -u root -p'password' newdb
mysql -u root -p'password' -e "drop database originaldb"

More Related Posts

• [2016/05/15] Disable MySQL Performance Schema
• [2016/05/20] Install Percona MySQL Server on Debian
• [2016/05/15] How to Recover MySQL Root Password
• [2016/05/15] Manage Remote MySQL Server with Local ...
• [2016/05/15] How to Change MySQL User Password
• [2016/05/15] Mysqli() Headers Client Library Minor ...
• [2016/05/15] Increase MySQL Max Connections Limit
• [2016/05/15] How to Create a MySQL Database