Database management

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.

 

 

  • 33 Users Found This Useful
Was this answer helpful?

Related Articles

File manager

The File manager module is specially designed to work with a file system through the...

Directory protection

This feature allows you to restrict the access to certain directories for specified users . You...

Domain names

A Domain name is a unique set of symbols (letters of the Latin alphabet, digits, hyphen and dot)...

Webmail access in ISPmanager

To access the default webmail client in ISP Manager (Squirrel Mail) use the address below:...

PhpPgAdmin

Via this module you can use phpPgAdmin. It is a web-based administration tool for PostgreSQL data...

Powered by WHMCompleteSolution