Amazon Relational Database Service
User Guide (API Version 2012-01-15)
Print this pageEmail this pageGo to the ForumsView the PDFShare this page on TwitterShare this page on FacebookBookmark this page on DeliciousSubmit this page to RedditSubmit this page to DiggDid this page help you?  Yes  No   Tell us about it...

Deleting a DB Instance

Deleting a DB Instance requires you to identify the instance you want to remove. You must also decide whether you want a final DB Snapshot. Without the DB Snapshot, you can't restore the DB Instance to its final state.

In the following examples, you delete a DB Instance both with and without a final DB Snapshot.

Deleting a DB Instance with No Final Snapshot

You can skip creating a final DB Snapshot if you want to quickly delete a DB Instance.

AWS Management Console

To delete a DB Instance with no final DB Snapshot

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the My DB Instances list, select the check box next to the DB Instance you wish to delete.

  3. Click the Delete button or right-click the DB Instance and select Delete from the context menu.

    The Delete DB Instance window appears.

  4. Select No in the Create final snapshot? drop-down list box.

  5. Click the OK button.

CLI

To delete a DB Instance with no final DB Snapshot

  • Use the command rds-delete-db-instance to delete an instance.

    PROMPT>rds-delete-db-instance mydbinstance mydbinstance --skip-final-snapshot

API

To delete a DB Instance with no final DB Snapshot

  • Call DeleteDBInstance with the following parameters:

    • DBInstanceIdentifier = mydbinstance

    • SkipFinalSnapshot = true

    Example

    https://rds.amazonaws.com/
    	?Action=DeleteDBInstance
    	&DBInstanceIdentifier=mydbinstance
    	&SkipFinalSnapshot=true
    	&SignatureVersion=2
    	&SignatureMethod=HmacSHA256
    	&Timestamp=2009-10-14T22%3A20%3A46.297Z
    	&AWSAccessKeyId=<AWS Access Key ID>
    	&Signature=<Signature>
    							

Deleting a DB Instance with a Final Snapshot

You can create a final DB Snapshot if you want to be able to restore a deleted DB Instance at a later time.

AWS Management Console

To delete a DB Instance with a final DB Snapshot

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the My DB Instances list, select the check box next to the DB Instance you wish to delete.

  3. Click the Delete button or right-click the DB Instance and select Delete from the context menu.

    The Delete DB Instance window appears.

  4. Select Yes in the Create final snapshot? drop-down list box.

  5. Type the name of your final snapshot into the Final snapshot name text box.

  6. Click the OK button.

CLI

To delete a DB Instance with a final DB Snapshot

  • Use the command rds-delete-db-instance to delete an instance.

    PROMPT>rds-delete-db-instance mydbinstance mydbinstance --final-snapshot-identifier myfinaldbsnapshot

    This command should produce output similar to the following:

    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
    DBINSTANCE  mydbinstance  2009-10-21T01:54:49.521Z  db.m1.large  MySQL  50  
       sa  deleting  us-east-1a  3
       SECGROUP  default  active
    					

API

To delete a DB Instance with a final DB Snapshot

  • Call DeleteDBInstance with the following parameters:

    • DBInstanceIdentifier = mydbinstance

    • FinalDBSnapshotIdentifier = myfinaldbsnapshot

    Example

    https://rds.amazonaws.com/
    	?Action=DeleteDBInstance
    	&DBInstanceIdentifier=mydbinstance
    	&FinalDBSnapshotIdentifier=myfinaldbsnapshot
    	&SignatureVersion=2
    	&SignatureMethod=HmacSHA256
    	&Timestamp=2009-10-14T22%3A20%3A46.297Z
    	&AWSAccessKeyId=<AWS Access Key ID>
    	&Signature=<Signature>