How can I Share and restore cloud sql backup files across account ( project )

I have a database in a Cloud SQL instance. I would like to copy its content into BigQuery in order to perform analysis. It is not a requirement for me to continuously update the BigQuery dataset. I...

I am trying to connect my gcloud VM to a mySQL instance also on the cloud, and keep getting this errror: ERROR 2005 (HY000): Unknown MySQL server host '[10.0.0.1]' (0) I have followed the instru...

My Java application needs to authenticate to Google cloud Mysql instance with SSL client authentication. Its client-key and certificate are provided by Google. I also need to setup JMX agent with S...

When exporting an sql database from an instance (2nd gen) and importing it on another sql instance, I get the following error: ERROR 1839 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set ...

I trying to import a database stored in the Cloud Storage using the command: gcloud sql instances import instance-name gs://connect-to-the-cloud-sql.appspot.com/my-cloud-sql-instance-backup But,...

I wanted to migrate from BigQuery to CloudSQL to save cost. My problem is that CloudSQL with PostgreSQL is very very slow compare to BigQuery. A query that takes 1.5 seconds in BigQuery takes almos...

I have two containers inside one pod. One is my application container and the second is a CloudSQL proxy container. Basically my application container is dependent on this CloudSQL container. The...

I would like to run database migrations written in node.js during the Cloud Build process. Currently, the database migration command is being executed but it seems that the Cloud Build process do...

Trying to migrate the database for an early project of mine to the cloud. Although the code that built everything is janky, the db structure and data itself are fairly sound. I could probably figur...

My goal should be quite straight forward: I have a PostgreSQL running in Cloud SQL, and want to use Datastream to transfer data to Big Query, within the same project, preferably through private IP ...

I am trying to set up Serverless VPC access Serverless VPC Access enables you to connect from your Cloud Functions directly to Compute Engine VM instances, Memorystore instances, Cloud SQL insta...

I am using a PostgreSQL instance running in Google Cloud SQL. I am trying to reset the pg_stat_statements because we made improvements to our tables and added some index. Unfortunately, when I try...

I have a Kubernetes JOB that does database migrations on a CloudSQL database. One way to access the CloudSQL database from GKE is to use the CloudSQL-proxy container and then connect via localhost....

I can't add "0.0.0.0/0" as an authorized network for my cloud sql. Error message from client: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 If I author...

This is the error that comes up when I try to use Cloud SQL Proxy to configure access to Google Cloud SQL in windows - "listen tcp 127.0.0.1:3306: bind: An attempt was made to access a socket in a ...

EDIT for present day readers This was a bug in an old version of DBeaver that was subsequently fixed. I am getting an 'access denied' error trying to connect to a Google Cloud SQL MySQL instance w...

I have multiple docker machines(dev,staging) running on Google Compute Engine which hosts Django servers(this needs access to Google Cloud SQL access). I have multiple Google Cloud SQL instances ru...

I am following the steps here, to setup a CloudSQL DB in Google Cloud Platform. I'm stuck at the step with: ./cloud_sql_proxy -instances="[YOUR_INSTANCE_CONNECTION_NAME]"=tcp:3306 I get the mes...

I have a Google Cloud SQL MySQL 2nd Gen 5.7 instance with 70GB of unused storage. I want to reduce the unused storage of my instance as this is one of the major hosting costs. The only way that I'...

I don't know how to explain this well, but I will try. I use Google Cloud SQL second edition with 20 GB disk size. I have several wp. databases with 166.5 MB Total size. And right now my Storage ...

I'm failing to test the ability to use an IAM user in Google Cloud's PostgreSQL offering. Here's my thinking process: I've set respective flag on my PostgreSQL instance on Google Cloud: $ gcloud s...

I have a tf script for provisioning a Cloud SQL instance, along with a couple of dbs and an admin user. I have renamed the instance, hence a new instance was created but terraform is encountering i...

I need to change the isolation level in the google cloud SQL , I searched a lot , but could not find it any where When i did SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED It gets changed...

I am not able to use the federated query capability from Google BigQuery to Google Cloud SQL Postgres. Google announced this federated query capability for BigQuery recently in beta state. I use ...