At Nimbus Retail you manage a Cloud SQL for MySQL instance called reporting-sql-01. The team needs to export a full database to Cloud Storage and later import it back into the same instance using gclo

Question

Options

• Agcloud sql export csv reporting-sql-01 gs://example-bucket-42/retail_backup.sql.gz -
• Bgsutil cp gs://example-bucket-42/retail_backup.sql.gz | gcloud sql import sql reporting-sql-01 -
• Cgcloud sql export sql reporting-sql-01 gs://example-bucket-42/retail_backup.sql.gz -
• Dgcloud sql import csv reporting-sql-01 gs://example-bucket-42/export.csv -database=analyticsdb -

• A
  2% (1)
• B
  13% (6)
• C
  80% (37)
• D
  4% (2)

Explanation

The gcloud sql export sql command exports the database as a mysqldump SQL file (optionally gzip-compressed when the destination ends in .gz), which can be directly re-imported with gcloud sql import sql-no format conversion required. Option A uses export csv, which produces a flat CSV file that cannot be used directly with import sql and requires schema recreation separately. Option B pipes gsutil output into an import command, which is not valid gcloud syntax. Option D uses import csv, which is an import command, not an export, and requires a pre-existing schema.

No community discussion yet for this question.