gcloud sql export bak

NAME

gcloud sql export bak - export data from a Cloud SQL instance to a BAK file

SYNOPSIS

gcloud sql export bak INSTANCE URI --database=DATABASE,[DATABASE,…], -d DATABASE,[DATABASE,…] [--async] [--bak-type=BAK_TYPE; default="FULL"] [--differential-base] [--export-log-end-time=EXPORT_LOG_END_TIME] [--export-log-start-time=EXPORT_LOG_START_TIME] [--stripe_count=STRIPE_COUNT] [--[no-]striped] [GCLOUD_WIDE_FLAG …]

DESCRIPTION

Export data from a Cloud SQL instance to a Google Cloud Storage bucket as a BAK backup file. This is only supported for SQL Server.

EXAMPLES

To export data from the database my-database in the Cloud SQL instance my-instance to a BAK file my-bucket/my-export.bak, run:

gcloud sql export bak my-instance gs://my-bucket/my-export.bak --database=my-database

POSITIONAL ARGUMENTS

INSTANCE

Cloud SQL instance ID.

URI

The path to the file in Google Cloud Storage where the export will be stored. The URI is in the form gs://bucketName/fileName. If the file already exists, the operation fails.

REQUIRED FLAGS

--database=DATABASE,[DATABASE,…], -d DATABASE,[DATABASE,…]

Database from which the export is made. Information on requirements can be found here: https://cloud.google.com/sql/docs/sqlserver/admin-api/v1beta4/instances/export#exportContext.databases

OPTIONAL FLAGS

--async

Return immediately, without waiting for the operation in progress to complete.

--bak-type=BAK_TYPE; default="FULL"

Type of bak file that will be exported, FULL or DIFF. SQL Server only. BAK_TYPE must be one of: FULL, DIFF, TLOG.

--differential-base

Whether the bak file export can be used as differential base for future differential backup. SQL Server only

--export-log-end-time=EXPORT_LOG_END_TIME

Optional flag. The end time of the transaction log files that are included in the export file. Use this flag to export transaction logs for Cloud SQL for SQL Server only. Format: YYYY-MM-DDTHH:MM:SSZ, UTC timezone only.

--export-log-start-time=EXPORT_LOG_START_TIME

Optional flag. The start time of the transaction log files that are included in the export file. Use this flag to export transaction logs for Cloud SQL for SQL Server only. Format: YYYY-MM-DDTHH:MM:SSZ, UTC timezone only.

--stripe_count=STRIPE_COUNT

Specifies the number of stripes to use for SQL Server exports.

--[no-]striped

Whether SQL Server export should be striped. Use --striped to enable and --no-striped to disable.

GCLOUD WIDE FLAGS

These flags are available to all commands: --access-token-file, --account, --billing-project, --configuration, --flags-file, --flatten, --format, --help, --impersonate-service-account, --log-http, --project, --quiet, --trace-token, --user-output-enabled, --verbosity.

Run $ gcloud help for details.

NOTES

These variants are also available:

gcloud alpha sql export bak

gcloud beta sql export bak