rename database
Rename mysql database using dbforge studio
-
Mark Allen commented
https://evidencedesk.io/ is a purpose-built SaaS platform for legal document and evidence management. Designed for law firms, corporate legal departments, and litigation professionals, it simplifies document intake, categorization, version control, and secure retrieval — all within a single, intuitive workspace.
-
XinWu Rui commented
This feature would save time for many users. When creating new databases, I often look for unique names to keep projects organized. For inspiration, I use a https://namyra.net to avoid boring default names. Hope Devart considers this suggestion.
-
Mark Allen commented
https://evidencedesk.io/ is a legal document and evidence management platform built for law firms. Organize case files, track chain of custody, and retrieve critical documents instantly — all in one secure workspace.
-
prakash
commented
Thank you for your valuable reply.
-
gr8kodr
commented
[QUOTE] From the MySQL Manual
RENAME DATABASE Syntax
RENAME {DATABASE | SCHEMA} <db_name> TO <new_db_name>;This statement was added in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL 5.1.23. It was intended to enable upgrading pre-5.1 databases to use the encoding implemented in 5.1 for mapping database names to database directory names. However, use of this statement could result in loss of database contents, which is why it was removed. Do not use RENAME DATABASE in earlier versions in which it is present.
To perform the task of upgrading database names with the new encoding, use ALTER DATABASE <db_name> UPGRADE DATA DIRECTORY NAME instead
[END QUOTE]In a round about manner, I was able to perform a Database rename (outlined below) within the IDE. However, for a large database with many tables, I can see that my technique is far from optimal ...
1. Create new DB -> `database1`
2. Add a couple of dummy tables (tbl1, tbl2)
3. Create a new DB `database2`
4. Duplicate the tables from database1 into database2 (individually)
5. DROP `database1`I believe that PhpMyAdmin uses the recipe above to perform the same task with the modification that it allows you move all tables to into the new DB by selecting each table behind the scenes
-
Anonymous
commented
Like PhpAdmin workbench