Exporting Data & Metadata

    Exporting Data

    OwnBackup provides its clients the ability to export Data and Metadata from the following options:

    • CSV
    • SQL 
    • SQL Endpoint 
    • Amazon S3
    • Exporting Metadata
    • Scheduled Exports

    Export all Backups to CSV

    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.

    Backup Summary

    In the Backup History list, select the Backup you wish to view, and the backup summary opens.

    Download an Individual Backup

    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.

    Export an Individual Backup

    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.

    Export to SQL

    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.

    Export to SQL Endpoint

    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.

    Export to Amazon S3

    Before you can upload data to Amazon S3, you must:

    • Create a bucket in one of the AWS Regions to store your data. You can find further information here.
    • 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.

    GetObject (read)
    PutObject (write)

    We use the get_public_access_block call to S3 in the verification step:

    • If the call succeeded but we see the S3 bucket is not secure, we will show an appropriate message in the UI.
    • If we get a connection error, we will show a connection error, otherwise, we will show a "you don't have read/write access" error.

    More info about the get_public_access_block call is documented here.

    Exporting Metadata

    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.

    Scheduled Exports

    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'.




    « Previous ArticleNext Article »

    Contact Us

    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