I am trying to rename my database's name in MySQL. The command I am using is ALTER command. I had also used RENAME command but it doesn't work. Names and spellings are correct. I am adding a screenshot for more clear understanding. Any help will be greatly appreciated. Version of MySQL is 8.0.MySQL
Asked
Active
Viewed 32 times
0
-
[Check](https://stackoverflow.com/questions/67093/how-do-i-quickly-rename-a-mysql-database-change-schema-name) if it helps – Ergest Basha Jan 05 '22 at 10:23
-
1) dump old db 2) edit database name in dump SQL file 3) import to new database. Is there any reason you cannot do this? – RiggsFolly Jan 05 '22 at 10:30