gcloud beta sql import sql - imports data into a Cloud SQL instance from a SQL dump file

gcloud beta sql import sqlINSTANCEURI[--async][--clean][--database=DATABASE,-dDATABASE][--if-exists][--parallel][--threads=THREADS][--user=USER][GCLOUD_WIDE_FLAG …]

NOTE: Certain roles and permissions are required to import data into GoogleCloud SQL. For more information on importing data into Google Cloud SQL seeImporta SQL dump file.

For detailed help on importing data into Cloud SQL, refer to this guide:https://cloud.google.com/sql/docs/mysql/import-export/importing

INSTANCE

Cloud SQL instance ID.

URI

Path to the MySQL dump file in Google Cloud Storage from which the import ismade. The URI is in the formgs://bucketName/fileName. Compressedgzip files (.gz) are also supported.

--async

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

--clean

Option to clean (DROP) database objects before recreating them. corresponds tothe clean flag for pg_restore. Only applies if --parallel is set. PostgreSQLonly.

--database=DATABASE,-dDATABASE

Database to which the import is made. The database needs to be created beforeimporting. If not set, it is assumed that the database is specified in the fileto be imported. If your SQL dump file includes a database statement, it willoverride the database set in this flag.

--if-exists

Include an SQL statement (IF EXISTS) with each DROP statement produced by--clean; corresponds to the if-exists flag for pg_restore. Only applies if--parallel is set. PostgreSQL only.

--parallel

Perform a parallel import. This flag is only applicable to MySQL and Postgres.

--threads=THREADS

Specifies the number of threads to use for the parallel import. If--parallel is specified and this flag is not provided, Cloud SQLuses a default thread count to optimize performance.

--user=USER

PostgreSQL user for this import operation.

Run$gcloud help for details.