Control Panel - Databases

From Amen Wiki

Jump to: navigation, search

Control Panel: Hosting.jpg HOSTING > CP_ico_db.gif Databases



Contents

[edit] Introduction

This set of tools will allow you to create, manage and delete your MySQL databases:

CP_Hosting_DB_EN.jpg

[edit] Information

This will show you the amount of databases created in your package and the space they use:

CP_Hosting_DB_01_EN.jpg

[edit] Database management

Here you will find a table of all your databases and the database creation interface:

CP_Hosting_DB_02_EN.jpg

[edit] Creating a new database

To create a new MySQL database for your pack take the following steps from DATABASE MANAGEMENT:

  1. Enter the description of the table (the description will allow you to know what the database is used for):

    CP_Hosting_DB_03_EN.jpg


  2. Select the MySQL version you want to work with:

    CP_Hosting_DB_04_EN.jpg


  3. Click on CP_Button_Add.png
  4. The new database will be added to the table while the creation is in progress:

    CP_Hosting_DB_05_EN.jpg


  5. Approximately 20 minutes later the creation will be confirmed and the status will change to Active:

    CP_Hosting_DB_06_EN.jpg


As the MySQL server is shared, names of databases are assigned by the system and cannot be changed.

[edit] Managing a database

Once the database has been created, you will be able to manage it by clicking on CP_ico_hosting_mysql_administration.jpg Edit:

CP_Hosting_DB_06_EN.jpg


The management screen has 3 sections.

[edit] Information

This section gives you basic information on your database (status, version and description):

CP_Hosting_DB_07_EN.jpg

[edit] Administration

This section includes all the details necessary to manage your database:

CP_Hosting_DB_08_EN.jpg


  • Server the database has been created on
  • phpMyAdmin interface: link to the URL where you can access your database via phpMyAdmin
  • Login and Password to connect to the server and access the database
  • New password and Confirm new password: if you want to modify the password for the database, just fill in both fields and click on Cp_button_modify_gray_en.png


As you can see on the main database listing table, the name of the database will be the same as the login for the server.

[edit] Reset database

This allows you to recreate or delete your database:

CP_Hosting_DB_09_EN.jpg


If you have more than one Web Pro + pack in your account, you will see the following tool:

CP_Hosting_DB_09_01_EN.jpg


This will allow you to move your database to another pack in your customer account.

[edit] Deleting a database

To delete a database:

  1. check the box to the right of the database you want to delete:

    CP_Hosting_DB_10_EN.jpg


  2. select Delete a database from the drop-down menu:

    CP_Hosting_DB_11_EN.jpg


  3. confirm the deletion by clicking on OK:

    CP_Hosting_DB_12_EN.jpg


  4. the database will be set to deleting in progress status:

    CP_Hosting_DB_13_EN.jpg



Back: [ Control Panel - Hosting ]
Personal tools
Toolbox