Can I run an sql file on my Google Cloud Sql instance using the gcloud sql command

user_3321579 0
Viewed 2274

I have an sql file that creates my mysql database and all my users and tables.

I am trying to figure out of there is a way I can automate using this sql file to initialize the database on my Google Cloud sql instance.

So far, the only way I have been able to determine, is that I use the gcloud sql connect command, and then just copy and paste the contents of the sql file into the mysql prompt.

There has got to be a better way though. Looking through the gcloud sql docs, I have not been able to find one. Am I missing something?

google-cloud-sql gcloud google-cloud-platform mysql
2 Answers
user_6092900

Steps to run an sql file on my Google Cloud Sql instance using the gcloud sql console are as follows:

  1. Create a GCP storage bucket (ideally in the same project)
  2. Upload the file to this bucket
  3. Import the sql file from this bucket in the overview section of the GCP SQL console

There is a comprehensive set of instructions here: virginia uni GCP DB setup

user_82526120
Related