The command creates a physical backup that has all database data along with stored procedures and functions.įollowing that, we need to use the above-mentioned command to create a new database: $ mysqladmin -u username -p'password' create newDbnameįinally, we need to import the dump file created in the first step to the new database: $ mysql -u username -p'password' newDbname < oldDbname.sqlĮven though this method appears to be straightforward, it may take considerable time when we deal with a larger database. To start with, we need to dump the old database by running the following command within your shell prompt: $ mysqldump -u username -p'password' -R oldDbname > oldDbname.sql After that, we can drop the old database if that’s necessary. This way, we can create a dumped copy of the database and import the whole database content into the new database. Dumping MethodĪnother way to rename a database in MySQL would be to use the mysqldump shell command. Instead of running the above-mentioned statement, we would have to drop and create them again. Besides, the RENAME TABLE command doesn’t work for views and triggers. Now that we have created an empty database, we need to move the tables one by one from the former database into the newly created database with the following command: RENAME TABLE oldDbname.table TO newDbname.table Īs you see, the query allows us to move the tables only one at a time, which isn’t very practical for large databases. But to do so, we first need to create a new database with the following mysqladmin shell command: $ mysqladmin -u username -p'password' create newDbname In a nutshell, we can apply the RENAME TABLE command within a MySQL prompt so as to alter the database name of a particular table while leaving the table name unchanged. In fact, MySQL version 5.5 (and later) has InnoDB Storage Engine as the default one, which can come in handy. There is a way to perform this task quite easily. The reason was that the RENAME DATABASE query could result in the loss of essential database contents, which clearly was undesirable. However, it became no longer available in the newer versions as it posed risks. For that purpose, we used to apply a simple RENAME DATABASE command that existed in earlier versions of MySQL. Eventually, it appears necessary to change the name of a database in MySQL.

Phpmyadmin rename database