Submitted by yngens on Fri, 08/29/2014 - 02:18
Virtualmin's database management is pretty robust, but either I am missing it or it doesn't have a feature to rename existing database. If there is indeed no such a feature I'd like to request to add it. Thanks!
Status:
Closed (works as designed)
Comments
Submitted by JamieCameron on Fri, 08/29/2014 - 11:30 Comment #1
This isn't trivial unfortunately, as MySQL has no support for renaming databases. Virtualmin would need to dump the whole contents of the DB to a temp file, delete the old one, create a new one, and then restore from the temp file ... which could be slow, and would take the DB offline during the process.
Submitted by yngens on Fri, 08/29/2014 - 17:51 Comment #2
I see. Well then let mark this as closed as it is not crucial feature to us too. I had just felt submitting such a request because in phpMyAdmin it is easily possible to rename databases with one click as it is show in the picture:
Submitted by JamieCameron on Fri, 08/29/2014 - 18:14 Comment #3
The MySQL docs say that this feature existed for a while, but was removed : http://dev.mysql.com/doc/refman/5.1/en/rename-database.html