Deleting your deployment and removing your data
IBM Cloud® Databases instances are softly deleted in production when you delete or deprovision the instance in IBM Cloud.
IBM Cloud keeps the deployment in the soft delete state for three days before it issues a delete. The soft delete state addresses use cases when you accidentally delete an instance. You can re-enable an existing soft-deleted instance on your own.
Because a soft delete is essentially a disablement, no Cloud Databases deployment can recover from a soft delete. Once an Cloud Databases deployment is deleted, that deployment must be restored from a backup.
Deleting your deployment in the user interface
To delete your deployment instance from the Resource list section dashboard of the IBM Cloud dashboard, select your deployment. Then, in the overflow menu ( ) click Delete service from the drop-down list.
Deleting your deployment by using the CLI
By using the CLI, you can delete your existing IBM Cloud® Databases instance with the ibmcloud resource service-instance-delete
command:
ibmcloud resource service-instance-delete <INSTANCE_NAME_OR_CRN>
Using the command ibmcloud resource reclamation-delete
deletes a reclaimed resource so that the resource can no longer be restored.
Deleting your database by using DROP DATABASE statement
DROP DATABASE
drops all tables in the database and deletes the database.
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name
Deleting your database by using mysqladmin
You can also drop databases with mysqladmin
, a MySQL Server Administration Program. Launch mysqladmin
like this:
mysqladmin [options] command [command-arg] [command [command-arg]] ...
Cryptoshredding keys
Key Protect provides for a force delete of a key that is in use by IBM Cloud® services, including your Cloud Databases deployments. This action is called cryptoshredding.
Cryptoshredding is a destructive action. When the key is deleted, your data is unrecoverable even from a soft delete state.
Backups removal
Backups cannot be manually deleted. However, if you delete your deployment, its backups are deleted automatically.
Reenabling from a soft delete
You are able to discover available soft-deleted instances by using the IBM Cloud CLI ibmcloud resource reclamations
command.
You can then "undelete", recover, or reclaim an available soft-deleted instance by using the IBM Cloud CLI ibmcloud resource reclamation-restore
command:
ibmcloud resource reclamation-restore resource_ID