Building Google Cloud Platform Solutions

Trying it out

In addition to the Cloud Console, backups may be created using gcloud. Try creating a backup of the hello-cloud-sql instance with the following command:

gcloud sql backups create -i hello-cloud-sql -d "initial backup"

Once created, you should see the new backup in the Cloud Console in the BACKUPS tab. Should the need arise, this backup can be restored at any time. As an example, execute the following command to delete our library database:

gcloud sql databases delete library -i hello-cloud-sql

You can verify that the database is gone by listing all databases:

gcloud sql databases list -i hello-cloud-sql

Should we need to recover the library database, we can simply perform a restore operation from the Cloud Console or gcloud. ...