# SQL

## Cloud SQL :

[![image-1636809431476.png](https://docs.nehemiebarkia.fr/uploads/images/gallery/2021-11/scaled-1680-/image-1636809431476.png)](https://docs.nehemiebarkia.fr/uploads/images/gallery/2021-11/image-1636809431476.png)

[![image-1636809525878.png](https://docs.nehemiebarkia.fr/uploads/images/gallery/2021-11/scaled-1680-/image-1636809525878.png)](https://docs.nehemiebarkia.fr/uploads/images/gallery/2021-11/image-1636809525878.png)

## Choisir Cloud SQL :

[![image-1636809604303.png](https://docs.nehemiebarkia.fr/uploads/images/gallery/2021-11/scaled-1680-/image-1636809604303.png)](https://docs.nehemiebarkia.fr/uploads/images/gallery/2021-11/image-1636809604303.png)

[![image-1636814946543.png](https://docs.nehemiebarkia.fr/uploads/images/gallery/2021-11/scaled-1680-/image-1636814946543.png)](https://docs.nehemiebarkia.fr/uploads/images/gallery/2021-11/image-1636814946543.png)

### <span style="text-decoration: underline;">**LES COMMANDES :** </span>

#### Prévoire une Backup à un temps t :

```bash
gcloud sql instances patch prod-sql-01 --backup-start-time 03:00
```

#### Désactiver la protection de suppression :

```bash
gcloud sql instances patch prod-sql-01 --no-deletion-protection
```

#### Supprimer une instance :

```bash
gcloud sql instances delete prod-sql-01 
```