The Database Configuration screen enables you to create and configure databases using the embedded HyperSQL server or connect to an external, supported database. You can also create and restore database backups, as well as port existing backups to a different type of database. For example, you could back up a HyperSQL database, then re-create it as an Oracle or MySQL database. Or, you could capture the current state of a database and use that for a rollback. 

Choose Database Configuration from the administration menu (gear icon) to open the Database Configuration screen.

In this section:

Configuring Database Settings

Connecting to an Existing Database

This process connects the current CTP to an existing CTP database.

1. Click Configure Database Settings and select Connect to existing CTP database in the window that appears.
   
2. Click Next.
   
   
3. Select a database type: HyperSQL, MariaDB, MySQL, Oracle, or PostgreSQL.

4. Enter the database URL and user credentials. See Database Settings below.

5. Click Test Connection to confirm that it is correct.
6. Click Save & Connect to connect to the database.

Creating a New Database

This process creates a new, empty CTP database. For information about creating a new CTP database from a backup, see Creating a Database from a Backup.

1. Click Configure Database Settings and select Create new CTP database, user, and schema in the window that appears.
   
2. Click Next.
   
   
3. Select a database type: HyperSQL, MariaDB, MySQL, Oracle, or PostgreSQL.
4. Enter the database URL and root credentials. See Database Settings below.
5. Click Test Connection to confirm that it is correct.
   

   For MySQL databases, the root user must have the GRANT OPTION privilege.

6. Click Next.
   
   

7. Enter new user and credentials and click Create Database.

Creating a CTP Schema for an Existing Database

This process creates a CTP schema for an existing database with existing user credentials.

1. Click Configure Database Settings and select Create CTP database schema in the window that appears.
   
2. Click Next.
   
   
3. Select a database type: HyperSQL, MariaDB, MySQL, Oracle, or PostgreSQL.
4. Enter the database URL and user credentials. See Database Settings below.
5. Click Test Connection to confirm that it is correct.
6. Click Create Schema.

Database Backups

Creating a Database Backup

To back up your CTP database, click Back Up Database on the Database Configurations page. What happens next depends on your database type:

• If the database is HyperSQL, MariaDB, or MySQL, the backup will begin immediately.

• If the database is Oracle, a dialog will appear asking for the data tablespace. Enter the name of the tablespace and click Create Backup and the backup will begin.

• If the database is PostgreSQL, a dialog will appear for the schema. Enter the name of the schema and click Create Backup and the backup will begin.

Once the backup is complete, you can click Download to download it to your device.

Backing Up Databases with Large Files (MySQL Only)

If you are using a MySQL database and the backup fails, try increasing the MySQL size limits as follows:

1. Find the my.cnf/my.ini file for your installation of MySQL. For MySQL 5.7, see http://dev.mysql.com/doc/refman/5.7/en/option-files.html. For other versions, see the appropriate manual at http://dev.mysql.com/doc/index.html.
2. Edit the file to use the parameter settings outlined below.
3. Restart the MySQL Service 

[mysqld]

• innodb = ON
• innodb_log_file_size = 5242880000 // This must be set to be 10x the largest content being loaded for the public marketplace.
• max_allowed_packet = 1G
• innodb_file_per_table = 1
• innodb_file_format = Barracuda 

[mysql]

• max_allowed_packet = 1G 

[client]

• max_allowed_packet = 1G

Creating a Database from a Backup

1. Click Create Database in the Database Connection Settings section.
2. Specify information about the new database  
3. Browse for a backup file In the Create from Backup File section and click Create.
   

A new database will be created in the specified location then it will be populated with the data saved in the backup file. After a new database is successfully created, CTP will ask you if you want it to delete the previous database (the database whose connection settings are shown in the main page behind the dialog).

Adding Multiple Databases