MGT CloudPanel - Databases

Adding a Database

  1. To add a new database, click on the left menu on Databases.

  2. Enter the name of the database and click on the button Create Database.

Adding a Database

Deleting a Database

  1. To delete a database, click on the left menu on Databases.

  2. Click on the delete button of the database you want to delete.

Adding a Database

Attention

Also all database backups from /home/cloudpanel/backups/$databaseName/ will be deleted.
You may want to take a copy before.

Adding a Database User

  1. To add a database user for a database, click on the left menu on Databases.

  2. Click on the view button:

View Database

  1. Enter the Username and Password and click on the button Create User.
Adding a Database User

Deleting a Database User

  1. To delete a database user for a database, click on the left menu on Databases.

  2. Click on the view button:

View Database

  1. Click on the button Delete to delete the user.
Delete Database User

phpMyAdmin

  1. To manage a database via phpMyAdmin, click on the view button of the database.

  2. Click on the button phpMyAdmin to manage the database.

Manage the database via phpMyAdmin

Database Backups

All databases are backed up once a night. The database dumps of each database can be found in the following directory:

/home/cloudpanel/backups/$databaseName/

Furthermore, we are doing full hourly backups of the entire instance, including all databases.

In case of an emergency, we can restore an instance from an image and restore a specific database.

All Multi and Auto Scaling environments that use Amazon RDS as database service can be restored to a specific time.

Remote Access

For remote database access, we need to whitelist IPs in the AWS security group.

Please open a technical support ticket and provide the IPs to whitelist.