google-cloud-platform - Any chance of restoring a deleted gcloud sql instance?

Question

Im obviously an idiot and I didn't sufficiently save data, but is there any chance of restoring a deleted gcloud sql instance that has been deleted, not just a db from backups because the whole instance has been deleted?

标签： google-cloud-platformgoogle-cloud-sqlgcloud

Answer 1

如果您足够快，实际上可以恢复它们。即使 Google 说它们已被删除，它们也应该仍然存在。

如果您知道已删除数据库的名称，请运行以下命令以检查它们是否仍然存在

gcloud sql backups list --instance=deleted-db-name --project your-project-name

如果你能看到任何结果，你是幸运的。尽快恢复它们！

gcloud sql backups restore <backup-ID> --restore-instance=new-db-from-scratch-name --project your-project

就是这样！

更多信息：https ://geko.cloud/gcp-cloud-sql-how-to-recover-an-accidentally-deleted-database/