CTP can help you backup and re-create/port the CTP database. From a backup file, you can re-create the exact same database in a new location, or you can port it to an alternative database type (MySQL, HyperSQL, Oracle). 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.
Creating a Backup
To back up a database:
- Choose Administration> Database Configuration.
- Click the Backup Database button. A dialog will open with a link to the zip file that’s created for the backup.
- Click the file link and save that backup file to a convenient location.
Creating a Database from a Backup
To create a new database from the backup (either an exact duplicate in a new location or a new version ported to another database type):
...
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).
Backing Up Databases with Large Files (MySQL Database Only)
If you are using a MySQL database and the backup fails, try increasing the MySQL size limits as follows:
...