Open Tech Notes

“Rename” database name in MySQL

Currently, there is no method to rename database name in MySQL, but you could easily use  mysqldump command backup  your database and then read it back in to a new database.

Step 1 Dump the database structure and content:

  mysqldump -u username -p dbname >> dump.sql

Step 2 Create a new empty database.
 
  mysql -u username -p dbname
  mysql> create database newdbname;

Step 3 Reload the database into a new database with a different name:

  mysql -u username -p newdbname < dump.sql