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.
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:
In the shortcuts
area of the Home pageMySQL Admin Tool (MySQL section).
In the MySQL submenu, click Create
Database. The Create Database form opens.
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, in the Database Name
field. You may choose to retain it or overwrite.
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.
The Database Administrator is assigned by your service provider at the
time of creating the site. This information is plugged into the Database Admin field and cannot be changed,
except by your service provider.
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
Site Administrator's Help
Published April 16, 2004