How to load data from Google compute engine to cloud SQL

0
votes

I'm new to Google Cloud Platform. I downloaded some *.csv files to Google Compute Engine (GCE) and did some transformations and saved the files in the storage linked to GCE. I found that I can install MySQL in GCE and load the data in there. But I want to load data to MySQL in Google Cloud SQL (GCS). Is there any way to load data from GCE to GCS.

TIA

1
mysqlgoogle-cloud-platformgoogle-compute-enginegoogle-cloud-sql
According to what you say your data is stored as *.CSV files in a Compute Engine instance right ? - Victor M Herasme Perez

1 Answers

2
votes

There is a guide on how to import CSV files into Cloud SQL instances. Just make sure the data you have fulfils the requirements.

In brief, you have to perform these steps:

  1. Create a storage bucket and upload your files there.

  2. Go to the console and there, go to the Cloud SQL instances page.

  3. Click the import button:

enter image description here

  1. Under Format, select CSV. Specify the Database and Table in your Cloud SQL instance where you wish to import the CSV file:

enter image description here

  1. Click the Import to start the import.

The more detailed guide is here.