The general usage instructions for the cloud management tool suite r3 can be found here.
Step 1 - Show help context
Usage of r3 db destr
~$ r3 db destroy -h
# Response
Destroy Restore-Snapshots/Database Servers of this Environment.
optional arguments:
-h, --help show this help message and exit
--loglevel {INFO,ERROR}
Define Loglevel for Execution (default: INFO)
--db-id DB_ID Destroy Restore-Database Server.
--snapshot-id SNAPSHOT_ID
Destroy Restore-Snapshot.
Step 2 - How do delete a restore-database?
Obtain the identifier of the database e.g. by listing the available databases using r3 db list --dbs command
Provide the identifier to the command line r3 db destroy --db-id as shown in the example.database restore example
~$ r3 db destroy --db-id restore-db-2017-10-23-12-45
# Response
This is a destructive operation. It may cause data loss!
Project: backend Company: root360 Environment: test
+-----------------------------+-------------------------------------------------------------------------+--------+------------------+
| DataBaseIdentifier | Endpoint | Engine | DBInstanceStatus |
+-----------------------------+-------------------------------------------------------------------------+--------+------------------+
| restore-db-2017-10-23-12-45 | restore-db-2017-10-23-12-45.cw8zdc1gbk6g.eu-central-1.rds.amazonaws.com | mysql | deleting |
+-----------------------------+-------------------------------------------------------------------------+--------+------------------+