Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://cloud.google.com/sdk/gcloud/reference/sql/import/sql below:

gcloud sql import sql | Google Cloud SDK Documentation

Stay organized with collections Save and categorize content based on your preferences.

NAME

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

SYNOPSIS

gcloud sql import sql INSTANCE URI [--async] [--clean] [--database=DATABASE, -d DATABASE] [--if-exists] [--parallel] [--threads=THREADS] [--user=USER] [GCLOUD_WIDE_FLAG …]

DESCRIPTION

gcloud sql import sql imports data into a Cloud SQL instance from a SQL dump file in Google Cloud Storage.

NOTE: Certain roles and permissions are required to import data into Google Cloud SQL. For more information on importing data into Google Cloud SQL see Import a 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

EXAMPLES

To import data from a SQL dump file into a database, testdb, on the specified Cloud SQL instance test-instance-1, run:

gcloud sql import sql test-instance-1 gs://test-bucket/test-file.sql.gz --database=testdb

POSITIONAL ARGUMENTS

INSTANCE

Cloud SQL instance ID.

URI

Path to the MySQL dump file in Google Cloud Storage from which the import is made. The URI is in the form gs://bucketName/fileName. Compressed gzip files (.gz) are also supported.

FLAGS

--async

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

--clean

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

--database=DATABASE, -d DATABASE

Database to which the import is made. The database needs to be created before importing. If not set, it is assumed that the database is specified in the file to be imported. If your SQL dump file includes a database statement, it will override 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 SQL uses a default thread count to optimize performance.

--user=USER

PostgreSQL user for this import operation.

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 import sql

gcloud beta sql import sql

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-05-07 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-05-07 UTC."],[],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4