How to rename database using phpMyAdmin tool?

Question

I created a fresh database in phpmyadmin which does not contain any tables yet since its fresh, however I accidentally made a typo. How can I rename the database?

If this happens to me I usually just execute the SQL command:

DROP DATABASE dbname;

and create another database. But is it possible to rename it? I was already searching SO but found nothing helpful.

Possible duplicate of [Rename mysql database?](https://stackoverflow.com/questions/13643802/rename-mysql-database) — waka, Aug 18 '17 at 12:28
Possible duplicate of [How do I quickly rename a MySQL database (change schema name)?](https://stackoverflow.com/questions/67093/how-do-i-quickly-rename-a-mysql-database-change-schema-name) — tima, Aug 18 '17 at 12:29

Black · Accepted Answer · 2017-08-18T12:42:59.923

1

I found two possible solutions.

Rename it via the phpmyadmin backend UI (preferable):

Or just execute this SQL (only use it if the database is fresh and does not contain any data yet, otherwise it will be lost!)

CREATE DATABASE newname;

DROP DATABASE oldname;

edited Aug 18 '17 at 12:42

answered Aug 18 '17 at 12:34

Black

18,150
39
158
271

score 0 · Answer 2 · answered Aug 18 '17 at 12:30

0

ALTER DATABASE oldName MODIFY NAME = newName

answered Aug 18 '17 at 12:30

DotNetLover

229
1
4
11

I get `Error in SQL Syntax` – Black Aug 18 '17 at 12:31
EXEC sp_renamedb 'oldName', 'newName' – DotNetLover Aug 18 '17 at 12:34

score 0 · Answer 3 · answered Aug 18 '17 at 12:30

I don't think you can do this. I think you'll need to dump that database, create the newly named one and then import the dump.

If this is a live system you'll need to take it down. If you cannot, then you will need to setup replication from this database to the new one.

If you want to see the commands try this link, Rename MySQL database

score 0 · Answer 4 · answered Aug 18 '17 at 12:34

Try using an aux temporary db (as copy of the original)

$ mysqldump dbname > dbname_dump.sql //create a backup
$ mysqladmin create dbname_new //create your new db with desired name
$ mysql dbname_new < dbname_dump.sql //restore the backup to the new one
$ mysql drop database dbname; //drop old one

How to rename database using phpMyAdmin tool?

4 Answers4