Cannot alter schema name in MYSQL 5.5 w/ MYSQL Workbench

mysql database schema mysql-workbench
GrayFullBuster picture GrayFullBuster · Dec 4, 2012 · Viewed 24.4k times · Source

Why I cannot alter my schema name from the MYSQL Workbench? Am i missing something? :(

As you can the name is dissabled

enter image description here

Answer

Gavin Towey picture Gavin Towey · Dec 4, 2012

There is no RENAME available for schema names. You will have to export the schema, then import with a new database name.

This is a limitation of the MySQL server itself.

Related questions

How to Schema Diff two databases using MySQL Workbench?

Does anyone know how to pull a database Scheme Diff for two databases using MySQL Workbench. v5.2 states it has this feature, but I can't seem to find it. I must use MySQL Workbench.

Read More
How do I show the schema of a table in a MySQL database?

From the MySQL console, what command displays the schema of any given table?

Read More
Difference Between Schema / Database in MySQL

Is there a difference between a schema and a database in MySQL? In SQL Server, a database is a higher level container in relation to a schema. I read that Create Schema and Create Database do essentially the same thing …

Read More