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/15] Increase MySQL Max Connections Limit
- [2016/05/15] How to Change MySQL User Password
- [2016/05/15] How to Recover MySQL Root Password
- [2016/05/15] Mysqli() Headers Client Library Minor ...
- [2016/05/15] How to Create a MySQL Database
- [2016/05/15] Manage Remote MySQL Server with Local ...
- [2016/05/20] Install Percona MySQL Server on Debian