A database is a collection of data organized by means of a database management system, such as MySQL or Postgres. Normally it is a set of interrelated tables that consist of columns (fields) and records. Databases allows you to manage large amounts of information over the web. They can be used to run web-based applications as well.
This module can be used to manage your databases. You may add, edit, delete the database, download its dump, create a list of users for a specific database and use other functions, if necessary.
Please note, that it may take much time to display the whole list due to great number of databases on your server and count of size of each database. In this case you should disable the size column by specifying the HideDbSize option in the control panel configuration file.
View the databases list
- Database name - name of the database.
- Database type - type of the database, such as MySQL.
- Database user - login that is used to access the database.
- Owner - control panel user whose disk quota includes the database size.
- Size (MB) - disk space (in Megabytes) occupied by database files.
Create a new database
To create a new database, click the "New" icon and fill out the form.
- Database name - enter a name for the database.
- Database type - select a type of the database you want to add.
- Owner - select the control panel user who will be the owner of the database.
- Database encoding - provide default database encoding
- Database user - select the database user who will be able to access the database. If you want to create a new user, choose the top line.
- New user name - enter a new database user name.
- Password - enter a password to access the database. The field cannot be blank, too short or simple.
- Re-enter password - retype the password to ensure that it has been entered correctly.
- Allow remote access - check the box to allow the user to access the database from a remote computer. If the box is not checked only local access will be permitted
Edit database parameters
To edit a database, locate the database you wish to edit, click the "Edit" icon and modify the settings you want to change.
Delete database
To delete a database, select it from the list and click the "Delete" icon. Confirm that you want to delete the selected database by clicking "OK" in the following window.
Check database
Sometimes you may experience problems using your databases. To check your databases for errors, select it from the list and click the "Repair" icon. Confirm that you want to check the selected database by clicking "OK" in the following window.
Download damp
You may download the database dump to a local computer. Select a database and click the "Download" icon.