Database management (ISPmanager)

From ISPWiki

Jump to: navigation, search

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.

Module«Databases»


Image:T-bullet.gif View a list of databases
Image:T-new.png Create new database
Image:T-edit.png Edit database parameters
Image:T-delete.png Delete database
Image:T-users.png Database users
Image:T-aid.png Check database
Image:T-download.png Download damp
Image:T-download.png Back up database
Image:T-upload.png Restore database
Image:T-filter.png List filter

View a list of databases

  • 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 new database

To create a new database, click the "New" icon and fill out the form:

module«databases»
  • Database name - enter a name for the database. You may use the Latin alphabet letters, figures and the "_" symbol.
  • Database type - select a type of the database you want to add.
  • Owner - select the control panel's user who will be the owner of the database.
  • Database encoding - select 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, select "Create new user".
  • New user name - enter a username for access to the database.
  • 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. Otherwise, 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

If you experience some problems using your databases, you may check them for errors. Select a database and click the "Repair" icon. Confirm that you want to check the selected database by clicking "OK" on the following form.

If one or several error are detected while checking the database, you will see a read banner containing the description of the problem and instructions how to solve it.

Download damp

You may download the database dump to a local computer. Select a database and click the "Download" icon.

Back up database

If you want to back up a database, select it, click the "Back up" icon and fill out the form providing a path (relative or absolute in relation to the user's home directory) to the backup copy file.

Please note! This function is only supported in ISPmanager for Windows and if MSSQL database is used.

Restore database

If you want to restore a database, select it, click the "Restore" icon and fill out the form providing a path (relative or absolute in relation to the user's home directory) to the backup copy file.

Please note! This function is only supported in ISPmanager for Windows and if MSSQL database is used.

List filter

You can use the list filter to search the information about database by specific parameters. To initiate searching, click the "Filter" icon and fill out the form. You do not need to fill out all the fields. This search can be carried out by its name, type, owner and size.

Once the filter is set, the list will be filtered by the selected database. You can clear the filter that you have previously set by clicking the "Remove filter" button.

Retrieved from "http://en.ispdoc.com/index.php/Database_management_(ISPmanager)"
Was this helpful? Yes | No
Personal tools