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 How do I quickly rename a MySQL database (change schema name)? — tima
– tima, Commented Aug 18, 2017 at 12:29

Black · Accepted Answer · 2017-08-18 12:42:59Z

2

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, 2017 at 12:42

answered Aug 18, 2017 at 12:34

Black

20.9k47 gold badges188 silver badges300 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DotNetLover · Accepted Answer · 2017-08-18 12:30:11Z

0

ALTER DATABASE oldName MODIFY NAME = newName

answered Aug 18, 2017 at 12:30

DotNetLover

2391 gold badge4 silver badges11 bronze badges

2 Comments

Black Over a year ago

I get Error in SQL Syntax

DotNetLover Over a year ago

EXEC sp_renamedb 'oldName', 'newName'

knight007 · Accepted Answer · 2017-08-18 12:30:23Z

0

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

answered Aug 18, 2017 at 12:30

knight007

557 bronze badges

Comments

aaron0207 · Accepted Answer · 2017-08-18 12:34:15Z

0

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

answered Aug 18, 2017 at 12:34

aaron0207

2,3531 gold badge20 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to rename database using phpMyAdmin tool?

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related