Import and export data in a cloud database

Data export

You can export database content to a file in JSON or CSV format. Each row in the exported file corresponds to a record in the database.

Procedure

1. On the Cloud database management page, click your target database.

2. On the Data tab, click Export.

3. On the export page, select an Export format, enter the Fields to export, and then click OK.

Data import

You can import a JSON or CSV file into a database. Each row in the imported file corresponds to a record in the database.

A JSON file must meet the following format requirements:

• Each line must be a complete JSON object. It cannot be a JSON array or a primitive data type.

• In the JSON-formatted data, the key in each key-value pair cannot start or end with a period (.), and cannot contain consecutive periods (..).

• Key names cannot be duplicates.

For a CSV file, the first row is used as the key names, separated by commas (,). The remaining rows are the data records that correspond to the key names in the first row.

The import supports two Conflict handling modes.

• Insert mode: The system attempts to insert the data from the file. If a primary key conflict or a unique index conflict occurs during the import, the record is ignored. The remaining data is not affected.

• Upsert mode: The system checks if a record exists. If the record exists, it is updated. If the record does not exist, it is inserted. If a unique index conflict occurs, the import operation is aborted.

Procedure

1. On the Cloud database management page, click the target database.

2. On the Data tab, click Import.

3. On the import page, click Upload File. Select a local file to upload. Then, select a conflict handling mode and click OK.

   Note

   • If the file does not contain an _id field, an _id is automatically generated during the import.

   • If the file contains an _id field, it must be in the oid format. For example:

     {"_id":{"$oid":"639be0d05321300af2bd273d"},"name":"test"}.

   • The format of the import file must be the same as the export file format. The file must use UTF-8 encoding. The maximum size for an import file is 50 MB.

   • The import operation is not an atomic operation. Some data may be imported successfully while other data may fail to import.

   • If you import a large amount of data, the import may take a long time. Wait for the import to complete.

Error code descriptions