Mengimpor data cadangan database MySQL 5.7 yang dikelola sendiri ke RDS.
Deskripsi operasi
Mesin yang didukung
RDS MySQL
Deskripsi
Cadangan pengguna merujuk pada data cadangan penuh database MySQL yang dikelola sendiri. Anda dapat memulihkan cadangan pengguna ke cloud.
Catatan
Untuk memanggil API ini, Anda harus memenuhi kondisi berikut:
Anda telah menggunakan XtraBackup untuk mencadangkan database MySQL 5.7 atau 8.0 yang dikelola sendiri, dan nama file cadangan diakhiri dengan
_qp.xb. Untuk informasi lebih lanjut, lihat Migrasi data penuh dari database MySQL 5.7 atau 8.0 yang dikelola sendiri ke cloud.Anda telah mengunggah file cadangan database MySQL 5.7 atau 8.0 yang dikelola sendiri ke bucket OSS di wilayah yang sesuai. Untuk informasi lebih lanjut, lihat Migrasi data penuh dari database MySQL 5.7 atau 8.0 yang dikelola sendiri ke cloud.
Coba sekarang
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
rds:ImportUserBackupFile |
create |
*DBInstance
|
None | None |
Parameter permintaan
|
Parameter |
Type |
Required |
Description |
Example |
| RegionId |
string |
Yes |
ID wilayah instans RDS. Anda dapat memanggil DescribeRegions untuk mendapatkannya. Catatan
|
cn-hangzhou |
| Mode |
string |
No |
Mode impor. Nilai valid:
|
oss |
| EngineVersion |
string |
No |
Versi database MySQL. Saat ini, 5.7 dan 8.0 didukung. |
5.7 |
| BucketRegion |
string |
No |
ID wilayah tempat bucket OSS yang menyimpan file cadangan database MySQL 5.7 yang dikelola sendiri berada. Anda dapat memanggil DescribeRegions untuk mendapatkan ID wilayah. |
cn-hangzhou |
| BackupFile |
string |
No |
Array JSON yang menjelaskan informasi tentang file cadangan di bucket OSS. Contoh:
Parameter dalam array dijelaskan sebagai berikut:
|
{"Bucket":"test", "Object":"test/test_db_employees.xb","Location":"ap-southeast-1"} |
| Comment |
string |
No |
Keterangan cadangan pengguna yang akan diimpor. |
BackupTest |
| RestoreSize |
integer |
No |
Kapasitas penyimpanan yang diperlukan untuk memulihkan cadangan pengguna. Unit: GB. Catatan
|
20 |
| Retention |
integer |
No |
Periode retensi file cadangan pengguna. Unit: hari. Nilai harus berupa bilangan bulat yang lebih besar dari 0. |
30 |
| ZoneId |
string |
No |
ID zona. Anda dapat memanggil DescribeRegions untuk mengkueri. Catatan
|
cn-hangzhou-b |
| ResourceGroupId |
string |
No |
ID kelompok sumber daya. Anda dapat memanggil DescribeDBInstanceAttribute untuk mendapatkannya. |
rg-acfmy**** |
| DBInstanceId |
string |
No |
ID instans. |
rm-uf6wjk5**** |
| SourceInfo |
string |
No |
Array JSON (case-sensitive) yang berisi informasi sumber cadangan penuh. Contoh:
Parameter dalam array dijelaskan sebagai berikut:
Catatan
Parameter ini hanya berlaku untuk instans dengan replikasi native. Parameter |
{"sourceIp":"172.20.xx.xx","sourcePort":"9999"} |
| BuildReplication |
boolean |
No |
Apakah akan membangun replikasi secara otomatis. Nilai valid:
Catatan
Parameter ini hanya berlaku untuk instans dengan replikasi native. Parameter |
true |
| MasterInfo |
string |
No |
Array JSON (case-sensitive) dari informasi master untuk menyiapkan replikasi MySQL. Contoh:
Parameter dalam array dijelaskan sebagai berikut:
Catatan
Parameter ini hanya berlaku untuk instans dengan replikasi native. Parameter |
{"masterIp":"172.20.xx.xx","masterPort":"3306","masterUser":"replica","masterPassword":"W33uopkehBQ="} |
Elemen respons
|
Element |
Type |
Description |
Example |
|
object |
Detail parameter tanggapan. |
||
| BackupId |
string |
ID cadangan pengguna. |
b-n8tpg24c6i0v**** |
| RequestId |
string |
ID permintaan. |
A140DD14-DCC9-4548-9C72-52A49A58A310 |
| Status |
boolean |
Apakah cadangan pengguna berhasil diimpor. Jika ya, true dikembalikan. Jika tidak, pesan error dikembalikan. |
true |
Contoh
Respons sukses
JSONformat
{
"BackupId": "b-n8tpg24c6i0v****",
"RequestId": "A140DD14-DCC9-4548-9C72-52A49A58A310",
"Status": true
}
Kode kesalahan
|
HTTP status code |
Error code |
Error message |
Description |
|---|---|---|---|
| 400 | InvalidOssBackupFile.InvalidFile | The specified OSS backup file is invalid. | |
| 400 | OperationDenied.Product | The product code is not supported. | |
| 400 | InvalidBackupFile.Format | The specified params BackupFile(BackupId or RestoreTime or BackupFile) is not valid. | |
| 400 | Order.ComboInstanceNotAllowOperate | A package instance is not allowed to operate independently. | |
| 400 | Price.PricingPlanResultNotFound | Pricing plan price result not found. | |
| 400 | Order.NoRealNameAuthentication | You have not passed the real-name authentication and do not meet the purchase conditions. Please log in to the user center for real-name authentication. | |
| 400 | InsufficientAvailableQuota | Your account quota limit is less than 0, please recharge before trying to purchase. | |
| 400 | CommodityServiceCalling.Exception | Failed to call commodity service. | |
| 400 | RegionDissolvedEOM | Dear customer, Alibaba Cloud plans to optimize and adjust the current region. Cloud services in this region will cease operations. You are currently unable to operate new purchase orders. Thank you for your understanding and support. | |
| 400 | Commodity.InvalidComponent | The module you purchased is not legal, please buy it again. | |
| 400 | RegionEndTimeDissolvedAustralia | Cloud services in the Australia (Sydney) region will be discontinued. Set the validity date to September 30, 2024 or earlier than September 30, 2024. | |
| 400 | Price.CommoditySys | Commodity system call exception. | |
| 400 | Pay.InsufficientBalance | Insufficient available balance. | |
| 400 | Order.PeriodInvalid | There is a problem with the period you selected, please choose again. | |
| 400 | pay.noCreditCard | Account not bound to credit card. | |
| 400 | Order.InstHasUnpaidOrder | There is an unpaid order for the service you have purchased. Please pay or void it before placing the order. | |
| 400 | noAvailablePaymentMethod | No payment method is specified for your account. We recommend that you add a payment method. | |
| 400 | BasicInfoUncompleted | Your information is incomplete. Complete your information before the operation. | |
| 400 | Risk.RiskControlRejection | Your account is abnormal, please contact customer service for details. | |
| 400 | Api.NotSupport | Specified api is not supported. | |
| 400 | ContainForbiddenLabelError | There is a label that prohibits placing orders. Please contact your distributor for assistance. | |
| 400 | InvalidDBInstanceId.NotFound | The DBInstanceId provided does not exist in records. | |
| 400 | InvalidInstanceLevel.DiskType | Specified instance level not support request disk type | |
| 400 | InvalidParam | Sepcified wal level Parameter is invalid. There are still logical slots in instance, so it can not be set as replica. | |
| 400 | KmsApiError | User secret key invalid. | |
| 400 | System.SaleValidateFailed | Sales expression validation system error. | |
| 400 | Abs.InvalidAccount.NotFound | account is not found. | |
| 400 | SqlExecuteFailedOrTimeout | sql command execution failed or timed out:%s. | |
| 400 | ColdData.EngineVersionNotSupport | The current instance engine version not support coldDataEnabled. | |
| 400 | ColdData.MinorVersionNotSupport | The current instance minor version not support coldDataEnabled. | |
| 400 | IncorrectTargetClasscode | The current instance type does not support this operation. | |
| 400 | InvalidConnectionString.Duplicate | Specified connection string already exists in the RDS. | |
| 400 | RequiredParam.NotFound | Required input param is not found. | |
| 400 | Parameters.Invalid | Parameter error, please check the parameters. | |
| 400 | BackupPolicyNotSupport | Cold Data won't open with CrossBackup or Flash Backup, please check Backup Policy. | |
| 400 | InvalideStatus.Format | The instance status does not support this operation. | |
| 400 | InvalidReleasedKeepPolicy.Format | Specified Released Keep Policy is not valid. | |
| 400 | InvalidDBInstanceEngineType.Format | the DB instance engine type does not support this operation. | |
| 400 | Pay.NoCreditCard | No credit cards. | |
| 400 | VpcNetworkTypeNotSupport | The vpc network type instance does not support this operation. | |
| 400 | MirrorInsExists | Specified DB instance mirror ins already existed. | |
| 400 | UnsupportedClassCode | The specified DB instance class stops selling. | |
| 400 | InvalidBackupSet | The specified database does not exist in the backup set. | |
| 400 | OrdTCommodityQueryError | Failed to query for product. | |
| 400 | ProductInstanceReleased | The instance has been released. Please check before placing the order. | |
| 400 | RegionEndTimeDissolvedIndia | The region is no longer supported. | |
| 400 | InvalidUserBakset | The user backup set to be imported is invalid. | |
| 500 | ExternalFailure | The request processing has failed due to external service failure. | |
| 500 | RequestMetaDataFailed | The service request failed. Please try again later or contact service personnel. | |
| 500 | InvokeProxyFailure | The request processing has failed due to service failure of rds api. | |
| 403 | OrderStatus.UnPaid | The specified db instance has unpaid order. | |
| 403 | InvalidReduceDiskSize | The storage capacity after the scale-down must be larger than the used amount. | |
| 403 | CloudSSDNotSupport | Cloud ssd does not support this operation, please upgrade to essd. | |
| 403 | InvalidUserOperatorPermission | The user permission does not support this operation. | |
| 403 | InvalidVswitchId | Specified conn vswitch id is not valid. | |
| 403 | IncorrectMinorVersion | Current engine minor version does not support operations. | |
| 403 | OperationDenied.ZoneResource | There is no available zone for inventory. | |
| 403 | NotInFlowController | Sorry,no permission. | |
| 403 | InvalidKmsKey | Kms key is disabled. | |
| 403 | InvalidInstanceLevel.Malformed | Current DB instance level does not support this operation. | |
| 404 | InvalidClusterKms | The current instance does not authorized to access the Key Management Service. | |
| 404 | Request.NotFound | The requested resource is not available. | |
| 404 | HostInfo.NotFound | The specified host info is not found. |
Lihat Error Codes untuk daftar lengkap.
Catatan rilis
Lihat Release Notes untuk daftar lengkap.