Resolved Rename a SQL database and missing option...

[raykai]

Hi,

Im trying to rename a database but i see no button for this option in plesk even tho this option was planed way back in 2014 https://plesk.uservoice.com/forums/184549-feature-suggestions/suggestions/3700423-rename-database

so i tried with the button phpmyadmin next to the database in question then i :
click on the name of the DB > Operations tab > Rename database to....
then i enter the name i want then i click on Go

but i get a error : #1044 - Access denied for user '****'@'localhost' to database 'DB NAME'

so i tried an other-way:
plesk panel > Tools & Settings > Database Servers > click on the tool icon
did like the other time it works but then if i go back to the Plesk panel > Website @ domain > go to the domain in question > databases.

it still shows the old DB name and if i click on phpmyadmin it gives me a empty list of DB....

so how is the correct way to rename a DB in plesk ?

 

[IgorG]

Not sure that this feature will be implemented in Plesk because RENAME DATABASE function was dropped in MySQL as potentially dangerous https://dev.mysql.com/worklog/task/?id=4030
For MSSQL you can try to use this solution - https://support.plesk.com/hc/en-us/articles/214527825