About multiple MySQL databases
Your hosting services make it possible to use multiple MySQL
databases with your site.
To use multiple MySQL databases, your service provider must enable the
MySQL option while creating the site and specify the number of databases
that you can create.
Web sites comprise data entities that can be organized in
databases enabling you to retrieve and process the data with ease. Often,
the volume of data can get overwhelming, and you will be challenged with
the need to distribute your data efficiently.
Multiple databases enable you to organize your site's data
more effectively and efficiently.
Your service provider determines the number of databases
that can be created for your site. As of now, the control panel supports
only one user per database.
The control panel does not implicitly create databases when a site is
created, even if the site is enabled to support the MySQL database service.
The disk space consumed
by a database counts toward a site's total disk quota. If a database consumes
disk space in excess of the site's disk quota, you will receive an error
stating that the disk is full.
The databases are
backed up when you back up the site.
MySQL databases are administered by the database administrator
designated by your service provider. Database administrators cannot create
or delete databases. You cannot change the name of the database administrator
though you can change the password.
To perform operations on a database as the Site Administrator, you must
be assigned the role of the Database Administrator by your service provider,
and log in using this information. You cannot
perform operations on a database using your site user name or password.
As a Site Administrator, you can:
Site Administrator's Help
Published April 16, 2004