| « PreviousNext » | |
  | Did this page help you? Yes | No | Tell us about it... |
rds-delete-db-instance
Description
Deletes a DB Instance. Once started, the process cannot be stopped, and the DB Instance will no longer be accessible. When you delete a DB instance, all automated backups for that instance are deleted and cannot be recovered. Manual DB Snapshots of the DB instance to be deleted are not deleted.
Syntax
rds-delete-db-instance
DBInstanceIdentifier [-f (--force) ]
[--final-db-snapshot-identifier value ]
[--skip-final-snapshot ] [General Options]
Options
| Name | Description | Required |
|---|---|---|
|
|
DB Instance identifier. |
Yes |
|
|
Forces no confirmation prompt for the delete operation. |
No |
|
|
Name for the final DB Snapshot. This option is not
permitted if the Constraints: Must contain 1 to 255 alphanumeric characters or hyphens. First character must be a letter. Cannot end with a hyphen or contain two consecutive hyphens. |
No |
|
|
Specifies that no final DB Snapshot should be made of the
DB Instance before it is deleted. This parameter must not be
specified if the |
No |
Output
The command returns the following information:
DBInstanceId—User-supplied database identifier; this is the unique key that identifies a DB Instance
Created—When the instance was created, in UTC
Class—The compute and memory capacity of the Amazon RDS instance
Engine—Name of the database engine to be used for this DB Instance
Storage—Initially allocated storage size specified in GBs
Master Username—The master username for the instance
Status—Status of the DB Snapshot. Valid values:
creating|available|deletingEndpoint Address—Address of the DB Instance
Port—The original port of the database from which the DB Snapshot was taken. This column appears only with the
--show-long-viewcommand optionAZ—The original Availability Zone of the database. This column appears only in the
--show-longviewPendingClass—The class to which the instance will be scaled during the next maintenance window, or to which it is currently being scaled if the
--apply-immediatelyoption was specified.PendingCredentials—The (hidden) master user password that will be applied to the DB Instance
PendingStorage—The storage size to which the instance will be scaled during the next maintenance window, or to which it is currently being scaled if the
--apply-immediatelyoption was specifiedVersion—The version number of the database engine.
Auto Minor Version Upgrade—Indicates that minor version upgrades will be applied to the DB Instance during the maintenance window. This column appears only in the
--show-longview.DB Name—Name of the initial database created when the instance was created (for the MySQL engine) or the Oracle System ID (SID) of the created DB Instance (for the Oracle engine). This column appears only in the
--show-longviewMaintenance Window—The period during which patching and instance modifications will be performed. This column appears only in the
--show-longviewName—Security Group name
Status—Status of authorization. Valid values:
authorizing|authorized|revokingGroup Name—Name of DB Parameter Group applied to
Apply Status—Status of applying the parameter group. Valid values:
in-sync|pending-reboot|applying
Examples
Delete a Database Instance with No Final DB Snapshot
This example deletes a DB Instance, forcing data deletion so no final DB Snapshot is created.
PROMPT>
rds-delete-db-instance databaseInstance1 --skip-final-snapshot
Once you begin deleting this database, it will no longer be able to accept connections.
Are you sure you want to delete this database? [Ny]y
Delete a Database Instance, Allowing a Final DB Snapshot
This example deletes a database, but specifies a final DB Snapshot.
PROMPT> rds-delete-db-instance databaseInstance1 --final-db-snapshot-identifier myfinalsnapshot
Once you begin deleting this database, it will no longer be able to accept connections.
Are you sure you want to delete this database? [Ny]y
Output Example with Column Headers
This example shows command output with column headers.
DBINSTANCE DBInstanceId Created Class Engine Storage Master Username Status Endpoint Address Port AZ PendingClass PendingCredentials
DBINSTANCE simcoprod01 2009-05-15 22:13:39.559 db.m1.large MySQL5.1 10GB master available mydbinstance.kldusfasddog.us-east-1.rds.am...us-east-1c
SECGROUP Name Status
SECGROUP Default authorized
PARAMGRP Group Name Apply Status
PARAMGRP mydbconfig in-sync
