Skip to main content

Backup data (logical backup)

The logical backup of NineData data backup service supports second-level RPO, row-level data recovery, and online backup data query functions. This article describes how to perform a logical backup of a database.

Prerequisite​

  • Data source already added to NineData. For how to add, see Manage Datasources.
  • The version of the MySQL data source is 8.0, 5.7, 5.6.
  • The version of the SQL Server data source is 2022, 2019, 2017, 2016, 2014, 2012, 2008R2.

Restrictions​

MySQL supports full and incremental backups, and SQL Server only supports full backups.

Steps​

  1. Log in to NineData console.

  2. On the left navigation bar, click Backup > Backup.

  3. On the Backup page, click Create Backup in the upper right corner.

  4. On the Sources & Target tab, configure according to the table below and click Next.

    Parameters
    		Description
    NameEnter the name of the backup task. For the convenience of subsequent search and management, please try to use a meaningful name. Up to 64 characters are supported.
    DatasourceSelect the data source to be backed up. For a newly added data source, please click Refresh on the right to get the latest list of data sources.
    Backup method (only for SQL Server)Select Logical Backup.
    • Logical backup : A backup method that uses database objects (such as tables, indexes, etc.) as backup objects. Support full backup, incremental backup, structure backup and other backup types.
    • Physical backup : A backup method that takes the files in the database as the backup object.
    Backup typeThe following backup types are supported:
    • Schema + Full Data + Log (only for MySQL): The backup data includes full and incremental data.
    • Schema + Full Data : The backup data contains full data.
    • Schema : Only the table Schema is backed up.
    Storage DestinationSelect the storage location of the backup data, according to the location of the data source. NineData provides multiple cloud vendors and multiple regions, and supports Alibaba Cloud, Tencent Cloud, Huawei Cloud, and AWS. For the supported regions, see the console.

  5. On the Objects & Periodic page, configure according to the following table, and click Save and Pre-Check.

    Parameters
    		Description
    Backup ObjectsThe content that needs to be backed up can be selected and customized.
    • All databases and objects : Backup all databases and objects in this data source.
    • Custom Objects : Manually select the databases and objects to be backed up.
    Backup Strategy
    • Time Zone : Select the desired time zone, the system will start the backup according to the time point in the time zone, the default is Beijing time zone.
    • Frequency : Choose how often to back up, any time period from Monday to Sunday, 00:00 to 23:59. if Every day is checked, back up will perform once a day.
    • Preservation Time : The preservation time of backup files (including backup files and log files), which will be automatically deleted after expiration. The options are 7 days, 30 days, 60 days, 90 days, half a year, 1 year, 2 years, and the default is 7 days.

  6. On the Pre-Check page, the system will automatically perform a system check, and the check result will be displayed on the page. If all checks are successful, click Launch.

    tip

    If the check fails, user needs to manually correct the failed items, and then reconfigure the backup task accordingly.

  7. After the Launch tab prompts that Launch Successfully, the data backup service will automatically start the backup according to the backup cycle. User can also click Backup now to make a backup immediately.

    tip

    User can also back up data immediately in the following two ways:

    • On the left navigation bar, click Backup > Backup, and on the Backup page, click Backup in the Actions column on the right side of the task to launch the backup.
    • On the left navigation bar, click Backup > Backup, and click the target Task ID on the Backup page, and click Backup in the upper right corner of the Details page.

  8. On the left navigation bar, click Backup > Backup, and click the target Task ID on the Backup page to view the detailed status of the backup task.

Last updated on