How to Rename a MySQL Database

You can’t rename a database directly. It’s a four-step process.

  1. mysql -u username -p -e “CREATE DATABASE new_dbname
  2. mysqldump -u username -p old_dbname > dbexport.sql
  3. mysql -u username -p new_dbname < dbexport.sql
  4. mysql -u username -p -e “DROP DATABASE old_dbname

Reference: MySQL Rename Table & Database Guide