MySQL Rename Database

Last Updated: 28 May, 2023

In MySQL, there is no direct command to rename a database. However, we can achieve the renaming of a database by following these steps:

• Create a new database with the desired name.

 CREATE DATABASE new_database;

• Copy all the tables, views, procedures, functions, and other database objects from the old database to the new one. We can use the mysqldump command to export the tables and import them into the new database.

 mysqldump -u <username> -p <old_database> | mysql -u <username> -p <new_database>

Replace <username>, <old_database>, and <new_database> with the appropriate values.

• Verify that the new database contains all the data from the old database.
• Drop the old database once the copying is complete.

 DROP DATABASE old_database;

Note: Be cautious when executing this command, as it permanently deletes the old database and its data.

By following these steps, you effectively rename the database by creating a new one with the desired name and transferring the data from the old database to the new database.