CODEWITHSUNDEEP
command-linescriptinggoogle-cloud-sqlgcloud
Chris Wood
Chris Wood

Reputation: 575

Bootstrapping Gcloud Cloud SQL 2nd Gen instance

My Bootstrapping effort for creating Cloud SQL 2nd gen instances went smoothly apart from one thing.

it refused to accept the parameter for MYSQL_5_7.

 C:\Program Files (x86)\Google\Cloud SDK>gcloud sql instances create ops-sql-2 --activation-policy=ALWAYS --backup --tier=db-n1-standard-2 --region=europe-west1 --gce-zone=europe-west1-b --database-version=mysql_5_7 --require-ssl  --assign-ip --backup-start-time=02:00
usage: gcloud sql instances create  INSTANCE [optional flags]
ERROR: (gcloud.sql.instances.create) argument --database-version: Invalid choice: 'mysql_5_7'.

Valid choices are [MYSQL_5_5, MYSQL_5_6, MYSQL_5_7, POSTGRES_9_5].

C:\Program Files (x86)\Google\Cloud SDK>gcloud sql instances create ops-sql- 2 --activation-policy=ALWAYS --backup --tier=db-n1-standard-2 --region=europe-west1 --gce-zone=europe-west1-b --database-version MYSQL_5_7 --require-ssl  --assign-ip --backup-start-time=02:00
ERROR: (gcloud.sql.instances.create) Invalid value for: MYSQL_5_7 is not a valid value:

is this a bug or am I missing something weird ? If it is a bug is there a method to get these sorted ASAP as I dont want to install MYSQL_5_6 which works fine in this script

Upvotes: 1

Views: 241

Answers (1)

user2701802
user2701802

Reputation:

Can you try "gcloud beta sql instances" instead of "gcloud sql instances"?

gcloud beta usually has the newest features/options: https://cloud.google.com/sdk/gcloud/reference/beta/

Upvotes: 2

Related Questions