Skip to main content

Restore logical backup data

If a database operation fails or data is lost, use NineData Backup and Restore to restore logical backup data to a database.

Before you begin​

Restrictions​

  • The restore target must use the same data source type as the backup data. For example, MySQL backup data cannot be restored to a SQL Server data source.
  • The restore target version must be greater than or equal to the version of the data source in the backup data. For example, MySQL 8.0 backup data cannot be restored to a MySQL 5.6 data source.
  • SQL Server logical backup currently does not support incremental backup, so point-in-time restore is not supported for SQL Server logical backup.
  • During full restore, if the database contains views (VIEW), functions (FUNCTION), stored procedures (PROCEDURE), or triggers (TRIGGER), do not configure object mapping in the Mapping step. Otherwise, the task fails.
  • Triggers (TRIGGERs) and events (EVENTs) created during incremental backup cannot be restored, but the resulting data changes are restored.
  • During restore, if the database contains views (VIEW), functions (FUNCTION), stored procedures (PROCEDURE), triggers (TRIGGER), or events (EVENT), the definer (DEFINER) of these objects is changed to the account used by the current restore task to access the database.
  • If a table has a foreign key (FOREIGN KEY), the foreign key constraint is not enforced during restore.

Procedure​

  1. Sign in to the NineData Console.

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

    tip

    Alternatively, open Backup > Backup Set, go to the Full Backup Set tab, find the target backup set ID, and click Restore in the Actions column.

  3. On the Restore Method tab, configure the parameters in the table, and click Next.

    Parameters
    		Description
    NameEnter a name for the restore task. Use a meaningful name to make the task easier to find and manage later. The name can contain up to 64 characters.
    SourceSelect the source of the backup objects. This helps you quickly locate the target Backup Task.
    Backup TaskSelect the backup task that contains the data required for restore.
    Restore MethodSelect one of the supported restore methods:
    • Restore by Time (MySQL only): Restores data based on full backup data and logs. This method can restore full data and subsequent incremental data. For the available restore time range, see the console.
    • Backup Set: Restores data from full backup data only. This method restores data to the point in time when the full backup completed, and does not include incremental data.
    Restore Time (MySQL only)Configure this parameter when Restore Method is Restore by Time. Select the point in time to restore to. When second-level RPO is available, restore data to any point in time from the backup start time to the current time.
    Backup SetConfigure this parameter when Restore Method is Backup Set. This restore option does not include incremental data.
    TargetSelect the target data source to restore backup data to.
    TypeConfigure this parameter when Restore Method is Backup Set. Select Schema, Full Data, or both. Expand Advanced to select how NineData handles tables with the same name or duplicate data.
    Advanced
    • Schema Conflict
      • Ignore Conflict and Continue: If a table with the same name exists, ignore the conflict and continue the restore task.
      • If object exists, STOP: If a table with the same name exists, stop the restore task.
    • Data Conflict
      • Ignore Conflict and Continue: If the same data exists, ignore the duplicate data and continue restoring other data.
      • If data exists, STOP: If the same data exists, stop the restore task.
      • Delete and Rewrite: Delete the existing data and write it again.

  4. On the Restore Objects tab, confirm the content to restore. Select Backup to restore all data, or select one or more Customized Objects to restore selected objects. Then click Next.

  5. On the Mapping tab, configure the table name to use after the table is restored to the target data source, and click Save and Pre-Check.

  6. On the Pre-check tab, wait for NineData to complete the pre-check. After the pre-check passes, click Launch.

    tip

    • If the pre-check fails, click Details in the Actions column for the failed check item, review and fix the issue, and run the pre-check again.

    • For warnings, review the message and decide whether to fix the item or continue.

  7. On the Launch tab, wait for the Launch Successfully message. Click View Details to open the restore task execution details, or click Back to List to return to the Restore list.

Result​

The restore task starts with the selected backup data, restore target, object scope, mapping, and conflict handling strategy. Monitor progress from the restore task details page.