Creating databases

Databases are not automatically created when your service provider enables MySQL for your site; you need to create them. Your service provider determines the number of databases you can create.

- Note: Disk space resource for a database is limited to the disk quota available for the site. If the database exceeds the available disk resources for the site, an error stating that the disk is full will be evidenced.

To create a database:

1. Click the Shortcuts tab on the Home page
   .

2. In the shortcuts area, click MySQL Administration Tool (MySQL section).

3. In the MySQL submenu, click Create Database. The Create Database form opens.

4. Enter a name for the database in the Database Name field. For uniqueness, the name of the database is prefixed with the corresponding Site ID. You may choose to retain it or overwrite.

5. 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.

- Note: The Database Administrator is assigned by your service provider at the time of creating the site. This information is pre-filled in the Database Administrator field and cannot be changed, except by your service provider.

5. Click Save.

If the database has been successfully created, it will be added to the list of current databases for the site. An appropriate message is displayed above the list of databases.

If the process fails, or succeeds with attendant warnings, click the Details link to view related information.