Skip to main content

Perform logical backup

NineData logical backup supports second-level RPO, row-level recovery, and online backup data query. Use a logical backup task to back up database objects, schedule recurring backups, and keep backup data for the retention period that you configure.

Before you begin​

  • The data source has been added to NineData. For details, see Add data sources.
  • The MySQL data source runs version 8.0, 5.7, or 5.6.
  • The SQL Server data source runs version 2022, 2019, 2017, 2016, 2014, 2012, or 2008R2.

Restrictions​

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

Procedure​

  1. Sign in to the NineData Console.

  2. In the navigation pane, click Backup > Backup.

  3. On the Backup page, click Create Backup.

  4. On the Sources & Target tab, configure the parameters in the table, and click Next.

    Parameters
    		Description
    NameEnter a name for the backup task. Use a meaningful name for later search and management. The name can contain up to 64 characters.
    DatasourceSelect the data source to back up. If the data source was added recently, click Refresh to load the latest data source list.
    Backup method (SQL Server only)Select Logical Backup.
    • Logical backup: Backs up database objects such as tables and indexes. Logical backup supports full backup, incremental backup, schema backup, and other backup types.
    • Physical backup: Backs up the database files.
    Backup typeSelect one of the supported backup types:
    • Schema + Full Data + Log (MySQL only): Backs up schema, full data, and incremental data.
    • Schema + Full Data: Backs up schema and full data.
    • Schema: Backs up table schemas only.
    Storage DestinationSelect the storage location for backup data based on the data source location. NineData provides multiple cloud vendors and regions, including Alibaba Cloud, Tencent Cloud, Huawei Cloud, and AWS. For supported regions, see the console.

  5. On the Objects & Periodic page, configure the parameters in the table, and click Save and Pre-Check.

    Parameters
    		Description
    Backup ObjectsSelect the objects to back up.
    • All databases and objects: Back up all databases and objects in the data source.
    • Custom Objects: Manually select the databases and objects to back up.
    Backup Strategy
    • Time Zone: Select the time zone for the backup schedule. The default is Beijing time.
    • Frequency: Select how often the backup runs. Choose any time range from Monday to Sunday, 00:00 to 23:59. If Every day is selected, the backup runs once per day.
    • Preservation Time: Select how long backup files and log files are retained before deletion. Options include 7 days, 30 days, 60 days, 90 days, half a year, 1 year, and 2 years. The default is 7 days.

  6. On the Pre-Check page, NineData checks the task configuration. If all checks pass, click Launch.

    tip

    If a check fails, review and fix the failed item, and then rerun the pre-check.

  7. After the Launch Successfully message appears on the Launch tab, NineData starts the backup based on the configured schedule. To run a backup immediately, click Backup now.

    tip

    Start an immediate backup in either of these ways:

    • In the navigation pane, click Backup > Backup. On the Backup page, click Backup in the Actions column for the target task.
    • In the navigation pane, click Backup > Backup. On the Backup page, click the target task ID, and then click Backup on the Details page.

  8. In the navigation pane, click Backup > Backup, and then click the target Task ID to view the backup task details.

Result​

The logical backup task is created and runs based on the configured schedule. Monitor task status from the backup task details page or run an immediate backup when needed.