gcloud sql export csv - exports data from a Cloud SQL instance to a CSV file

gcloud sql export csvINSTANCEURI--query=QUERY[--async][--database=DATABASE,[DATABASE,…],-dDATABASE,[DATABASE,…]][--escape=ESCAPE][--fields-terminated-by=FIELDS_TERMINATED_BY][--lines-terminated-by=LINES_TERMINATED_BY][--offload][--quote=QUOTE][GCLOUD_WIDE_FLAG …]

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, theoperation fails. If the filename ends with .gz, the contents are compressed.

--query=QUERY

A SQL SELECT query (e.g., SELECT * FROM table) that specifies the data toexport. WARNING: While in-transit, the query might be processed in intermediatelocations other than the location of the target instance.

--async

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

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

Database(s) from which the export is made. Information on requirements can befound here:https://cloud.google.com/sql/docs/mysql/admin-api/v1beta4/instances/export#exportContext.databases

--escape=ESCAPE

Specifies the character that should appear before a data character that needs tobe escaped. The value of this argument has to be a character in Hex ASCII Code.For example, "22" represents double quotes. This flag is only available forMySQL and Postgres. If this flag is not provided, double quotes character willbe used as the default value.

--fields-terminated-by=FIELDS_TERMINATED_BY

Specifies the character that splits column values. The value of this argumenthas to be a character in Hex ASCII Code. For example, "2C" represents a comma.This flag is only available for MySQL and Postgres. If this flag is notprovided, a comma character will be used as the default value.

--lines-terminated-by=LINES_TERMINATED_BY

Specifies the character that split line records. The value of this argument hasto be a character in Hex ASCII Code. For example, "0A" represents a new line.This flag is only available for MySQL. If this flag is not provided, a new linecharacter will be used as the default value.

--offload

Offload an export to a temporary instance. Doing so reduces strain on sourceinstances and allows other operations to be performed while the export is inprogress.

--quote=QUOTE

Specifies the character that encloses values from columns that have string datatype. The value of this argument has to be a character in Hex ASCII Code. Forexample, "22" represents double quotes. This flag is only available for MySQLand Postgres. If this flag is not provided, double quotes character will be usedas the default value.

Run$gcloud help for details.