Rename, delete, copy or move a database

See Also

Rename a Database

MySQL does not support the rename of a database through its command interface at the moment, but you can rename the database if you have access to the directory in which MySQL stores its databases. For default MySQL installations this is usually in the Data directory under the directory where MySQL was installed. Locate the name of the database you want to rename under the Data directory and rename it.

Note: You must stop MySQL before you can rename the database

Delete a Database

To delete a database, right-click on the database in the Server Navigator and select Delete. A confirmation dialog will prompt you before deleting the database.

Note: Be very careful when deleting a database, the operation is irreversible.

Copy a Database

You can copy a database from one server to another or to the same server under a different database name by using Mascon's Dump.

Move a Database

You can move a database from one server to another by copying the database to where you want it and then delete the original one.