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
這篇文章有幫助嗎?

Related Articles

ISP Manager features overview

Main Features FTP accounts     - create and manage FTP accounts. Domain names     - manage...

FTP Users

FTP is an abbreviation for a File Transfer Protocol, the protocol determining file transfers...

Domain names

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

WWW domains

A WWW domain (web-site) is a collection of pages and scripts available in the World Wide Web by a...

WWW domain log rotation

To effectively manage your web server, you need to get feedback about the activity and...

Powered by WHMCompleteSolution