/cloud-sql-basics

Cloud SQL CLI Usage

The gcloud sql command group is used to manage Cloud SQL instances and related resources.

Basic Syntax

gcloud sql [GROUP] [COMMAND] [FLAGS]

Essential Commands

Instance Management

• Create an instance:

  gcloud sql instances create my-instance --database-version=MYSQL_8_0 \
      --tier=db-f1-micro --region=us-central1 \
      --quiet

• List instances:

  gcloud sql instances list --quiet

• Describe an instance:

  gcloud sql instances describe my-instance --quiet

• Restart an instance:

  gcloud sql instances restart my-instance --quiet

Database and User Management

• Create a database:

  gcloud sql databases create my-db --instance=my-instance --quiet

• Create a user:

  gcloud sql users create my-user --instance=my-instance \
      --password=my-password \
      --quiet

Operations and Backups

• List operations:

  gcloud sql operations list --instance=my-instance --quiet

• Create a backup:

  gcloud sql backups create --instance=my-instance --quiet

• Restore from a backup:

  gcloud sql backups restore backup_id --restore-instance=my-instance --quiet

Common Flags

• --project: Specifies the project ID.

• --region: The region where the instance is located.

• --format: Changes output format (e.g., json, yaml).