Data export

In ApsaraDB for SelectDB, you can export and import data for backup and restoration by using the following methods.

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. 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.	Back up and restore any amount of data from a table on a SelectDB instance.