- NAME
- gcloud sql instances export - exports data from a Cloud SQL instance
- SYNOPSIS
-
gcloud sql instances export
INSTANCE
URI
[--async
] [--database
DATABASE
[DATABASE
…], -d
DATABASE
[DATABASE
…]] [--format
FORMAT
] [--help
] [--project
PROJECT_ID
] [--quiet
, -q
] [--table
TABLE
[TABLE
…], -t
TABLE
[TABLE
…]] [-h
]
- DESCRIPTION
- Exports data from a Cloud SQL instance to a Google Cloud Storage
bucket as a MySQL dump file.
- 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. If the filename ends with .gz, the contents are compressed.
- FLAGS
-
--async
-
Do not wait for the operation to complete.
-
--database
DATABASE
[DATABASE
…], -d
DATABASE
[DATABASE
…]
-
Database (for example, guestbook) from which the export is made. If unspecified, all databases are exported.
-
--table
TABLE
[TABLE
…], -t
TABLE
[TABLE
…]
-
Tables to export from the specified database. If you specify tables, specify one and only one database.
- GLOBAL FLAGS
-
--format
FORMAT
-
Specify a format for printed output. By default, a command-specific
human-friendly output format is used. Setting this flag to one of
the available options will serialize the result of the command in
the chosen format and print it to stdout. Supported formats are:
json
, text
, yaml
.
-
--help
-
Display detailed help.
-
--project
PROJECT_ID
-
The Google Cloud Platform project name to use for this invocation. If
omitted then the current project is assumed.
-
--quiet
, -q
-
Disable all interactive prompts when running gcloud commands. If input
is required, defaults will be used, or an error will be raised.
-
-h
-
Print a summary help and exit.
- NOTES
- This command is in the Google Cloud SDK
sql
component. See
installing components
if it is not installed.