Editing instances

After you create an instance, you can edit the instance at any time to change its settings. For information about instance settings and how changing settings can impact an instance, see Instance Settings.

Editing an instance

Console

  1. Go to the Cloud SQL Instances page in the Google Cloud Console.

    Go to the Cloud SQL Instances page

  2. Select an instance to edit by clicking the instance name.
  3. Click Edit.
  4. Make your changes to the instance settings.

    Learn more about instance settings.

  5. Click Save to apply your changes.

gcloud

The following command modifies the backup start time.

gcloud sql instances patch [INSTANCE_NAME] --backup-start-time 16:00

If the patch modifies a value that requires a restart, you will see a prompt to proceed with the change or cancel.

cURL

The following command modifies the backup start time.

gcloud auth login
ACCESS_TOKEN="$(gcloud auth print-access-token)"
curl --header "Authorization: Bearer ${ACCESS_TOKEN}" \
     --header 'Content-Type: application/json' \
     --data '{"settings" : {"backupConfiguration" : {"startTime": "16:00", "enabled": true, "binaryLogEnabled": true}}}' \
     -X PATCH \
     https://www.googleapis.com/sql/v1beta4/projects/[PROJECT-ID]/instances/[INSTANCE_NAME]

If the patch modifies a value that requires a restart, you will see a prompt to proceed with the change or cancel.

To see how the underlying REST API request is constructed for this task, see the APIs Explorer on the instances:patch page.
Was this page helpful? Let us know how we did:

Send feedback about...

Cloud SQL for MySQL
Need help? Visit our support page.