OwnBackup provides its clients the ability to export Data and Metadata from the following options:
In the Backup History you can view a list of the Backups list of all the backups performed. You can download all backups in CSV file format by clicking Export to CSV.
In the Backup History list, select the Backup you wish to view, and the backup summary opens.
You can download the backup as a CSV file, select whether to export All or specific objects, and whether to include attachments by clicking Download above the summary table.
You can export the backup to SQL, SQL Endpoint, and to Amazon S3 by clicking Export above the summary table.
All exports are manual but can be automated via the API.If you need to white list the incoming traffic into your MySQL, you can find more information here.
OwnBackup supports this feature with MySQL, Oracle, PostgreSQL, and MS-SQL databases. You can the select the format, and whether to export All or specific objects. To see the list of objects excluded from the export process see here.
When using the export to SQL feature, you can export your data backup into an SQL database, via a generated SQL script for download. This script can then be inserted into your database, upon which all of your data and relationships will be inserted.
If you have a My-SQL database, you can set up an endpoint, and then directly push your data from within OwnBackup to the database. This feature is currently available for MySQL and doesn't support Client Cert Auth connections which require an additional file beyond the SSL CA.
Before you can upload data to Amazon S3, you must:
Create a new S3 Endpoint in OwnBackup.
In the Backup History list, you can select the Backup you wish to use and export it to Amazon S3.
You can then select the endpoint, whether to export All or specific objects, and whether to include attachments.
The export creates a folder with the backup name under the path provided. The GZIP file created for each object is a zipped CSV file. The export uploads the files to this folder, if a file was previously uploaded (same backup, same object) the file is overwritten.
Here are the specific permissions required and the API call that OwnBackup makes to S3 to test connectivity with the bucket.
We use the get_public_access_block call to S3 in the verification step:
More info about the get_public_access_block call is documented here.
Export for metadata is also available in any metadata backup.
Click Export to CSV to download a folder labeled ‘metadata’.
Each metadata object is listed separately, as well as the package.xml file. Use any of these files to deploy metadata using your preferred Integrated Development Environment.
In the Schedule Exports menu, you can schedule an export of your backup to your existing endpoints.
When the Scheduled Export runs, it will run for your last successful full backup, and you can see the export in the Jobs tab under 'Scheduled backup export'.
Our Customer Support team is available by phone for urgent Production issues
Standard Plan: Monday – Friday: 9:00 AM – 6:00 PM Local Business Hours
Premier Plan: 24/7