Exporting Data & Metadata

    Exporting Data

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

    • To a SQL file (as a query) without attachments for MySQL, Oracle, PostgreSQL, and MS-SQL databases
    • To a MySQL Endpoint via the SQL Endpoint feature
    • To Amazon S3 with attachment
    • To a CSV

    Export all Backups

    You can download all backups in CSV file format.

    1. On the left-hand menu, click “Backup History”. The Backups list opens.
    2. At the top of the list click Export to CSV. The Backups.csv file downloads.
      1.  

    Download a Backup

    1. Above the table click Download. The Download CSV window opens.

    1. Select whether to export All or specific objects.

    2. If you selected Specific objects, select the objects you wish to export.

    3. Select whether to include attachments.

    4. Click Run. The Backup Export job begins and opens in the Jobs tab.

    1. Once the job completes, click the “click here to download" link to download the CSV.

      1.  

    Export a Backup

    1. In the Backup you wish to export, click Export. The Export Backup window opens.

    1. Select the format to export.

    Export your data backup into a 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. OwnBackup supports this feature with MySQL, Oracle, PostgreSQL, and MS-SQL databases.

    1. Select the Endpoint.
    2. Select whether to export All or specific objects.
    3. If you selected Specific objects, select the objects you wish to export.
    4. Select whether to include attachments.
    5. Click Export.

    When using export to SQL feature, the script can then be inserted into your database, upon which all of your data and relationships will be inserted.

    All exports are manual but can be automated via the API.
    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.



    If you need to white list the incoming traffic into your MySQL instance this article describes the OwnBackup instance IPs.

    Export to Amazon S3

    Export to Amazon S3 is also available. See the separate Knowledge Base article.

    Exporting Metadata

    Export for metadata is also available in any metadata backup. Exporting your entire metadata snapshot will download a folder labeled ‘metadata’, with each metadata object listed separately inside, as well as the package.xml file. You can use any of these files to deploy metadata using your preferred IDE.

     

     

     

    Attachments

    « Previous ArticleNext Article »


    Contact Us

    Sometimes you just want to talk to someone. 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