Re: Rename Database in Workbench

[JARYD REMILARD]

Unfortunately, there is no simple right click > rename.

You will have copy the data over to a new database and drop the old one. Likely, your dump probably included the database name in the file. When you create the dump double check the database name query at the top of the SQL file.

As to why there is no simple rename, I don't like to link share however this was well written; refer to https://stackoverflow.com/questions/12190000/rename-mysql-database

Exporting the data and importing can be followed here: https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html

When you create the dump, open the SQL file in a text editor and ensure you have the database name matching the new database name.