All Products
Search
Document Center

ApsaraDB for SelectDB:Data export

Last Updated:Apr 10, 2025

In ApsaraDB for SelectDB, you can use the following methods to export or import data to implement data backup or restoration.

Method

Description

Scenario

mysqldump

  • Data backup: Use mysqldump to export data of a SelectDB instance.

  • Data restoration: Use mysqldump to import the exported data back to the SelectDB instance.

You want to back up and restore full data of a SelectDB instance. This method is suitable for scenarios in which tens of GB of data is involved.

SELECT INTO OUTFILE

  • Data backup: Use SELECT INTO OUTFILE to export data of a SelectDB instance.

  • Data restoration: Use OSS Load to import the exported data back to the SelectDB instance.

You want to back up and restore any amount of data of a table on a SelectDB instance.