Rename entire Mysql Database

Asked

Viewed 6,085 times

0

I wonder if it is possible to rename a whole Mysql database

I have the Database Register with the people table

I would like to rename registration to CAD_CRS

It is possible?

mysql sql database

  • https://pt.blog.marceloaltmann.com/how-to-rename-a-database-in-mysql/

  • Don’t forget to make a complete backup of your website (website folder + database).

1 answer

3


Phpmyadmin has an operation for this.

In Phpmyadmin, select the database you want to rename. In the tabs, there is a call Operations, after that, go to the rename section.

Renomear DB

Or, create a new database with the new name, dump all tables from the old database into the new database and delete the old database.

Browser other questions tagged mysql sql database

You are not signed in. Login or sign up in order to post.