Changing database names

You can change the name of a database at any time.

To change a database's name:

  1. In the shortcuts area of the Home page, click MySQL Admin Tool (MySQL section).

  2. In the MySQL submenu, click List Databases. The MySQL Databases form opens.

  3. Click in the Actions column next to the database whose administrator information you want to change. The Rename MySQL Database form opens.

  4. Rename the database.

  5. Note: The prefix of the database cannot be changed.

  6. Important: Database names should not exceed the maximum limit of 64 characters, inclusive of the prefix. For example, if your database prefix is 30 characters long, you must restrict the name of your database to a maximum of 30 characters, to conform to the limit (64). Four characters are reserved for internal use.

  1. Click Save.

On successful renaming, an appropriate message appears in the Status panel.

Related Topics