Database Server

Import Mysql on Google Cloud

In the Cloud Shell of the ProjectFollow the URLhttps://cloud.google.com/sql/docs/mysql/import-export/import-export-sql#gcloud_11. Create a Cloud Storage bucket.Upload the file to your bucket.2. For he...

P
Prem Mohan Tyagi
1 min | 109 words
Import Mysql on Google Cloud

In the Cloud Shell of the Project

Follow the URL
https://cloud.google.com/sql/docs/mysql/import-export/import-export-sql#gcloud_1

1. Create a Cloud Storage bucket.

Upload the file to your bucket.

2. For help with uploading files to buckets, see Uploading objects.

3. Describe the instance you are importing to:

gcloud sql instances describe INSTANCE_NAME

4. Copy the serviceAccountEmailAddress field.

Use gsutil iam to grant the storage.objectAdmin IAM role to the service account for the bucket.

5. gsutil iam ch serviceAccount:SERVICE-ACCOUNT:objectAdmin \ gs://BUCKET-NAME

For help with setting IAM permissions, see Using IAM permissions.

Import the database:

6. gcloud sql import sql INSTANCE_NAME gs://BUCKET_NAME/IMPORT_FILE_NAME \ --database=DATABASE_NAME


Share this article

P

Written by

Prem Mohan Tyagi

Keep reading

You might also like

Hierarchical Tree Structures in MySQL
Mysql

Hierarchical Tree Structures in MySQL

A relational database stores data in flat tables rows and columns. But real-world data is often hierarchical: a company has departments, departments have teams, teams have employees. File systems have folders inside folders. Comment threads have replies inside replies. The challenge is that SQL tables have no built-in concept of "parent" or "child". We have to model that relationship ourselves. This article covers two ways to do it, using a company org chart as the running example.

Read
Mastering Firewall Rules with firewalld (Linux Security Guide)
Server

Mastering Firewall Rules with firewalld (Linux Security Guide)

Managing firewall rules is not just a server task — it is your first line of defense. A properly configured firewall protects your server from unnecessary exposure.

Read
MySQL DBA Mastery: Administration & Performance Guide
Mysql

MySQL DBA Mastery: Administration & Performance Guide

A complete and practical MySQL administration and performance guide covering user management, SSL configuration, database backup & restore, grants, monitoring, query optimization, troubleshooting, and production-ready DBA operations.

Read

Learn this step by step

Free tutorials on the topics covered in this article.

SQL Tutorial

SQL is the standard language for storing, manipulating, and retrieving data in databases. Learn queries, joins, subqueries, and database management.
MySQL Tutorial

MySQL is the world's most popular open-source relational database management system. Learn installation, queries, joins, and database administration.