Unable to create a MySQL database backup in GCP storage

Question

We deploy a laravel project in k8s(GCP) with mysql database. Now i want time to time backup of this database with the help of cronjob and I followed an articles but i'm unable to create a backup file. However, as per article we need to create the storage bucket and service account in GCP

It is working properly still there is no backup file in storage bucket.

cronjob.yaml file

apiVersion: batch/v1beta1 kind: CronJob metadata: name: backup-cronjob spec: schedule: "*/1 * * * *" jobTemplate: spec: template: spec: containers: - name: backup-container image: gcr.io/thereport/abcd env: - name: DB_NAME valueFrom: configMapKeyRef: name: backup-configmap key: db - name: GCS_BUCKET valueFrom: configMapKeyRef: name: backup-configmap key: gcs-bucket - name: DB_HOST valueFrom: secretKeyRef: name: backup key: db_host - name: DB_USER valueFrom: secretKeyRef: name: backup key: username - name: DB_PASS valueFrom: secretKeyRef: name: backup key: password - name: GCS_SA valueFrom: secretKeyRef: name: backup key: thereport-541be75e66dd.json args: - /bin/bash - -c - mysqldump --u root --p"root" homestead > trydata.sql; gcloud config set project thereport; gcloud auth activate-service-account --key-file backup; gsutil cp /trydata.sql gs://backup-buck



      restartPolicy: OnFailure

Hello, do your kube service account have access to write objects in your bucket? for a quick try (not for real implementation) make your bucket public and try to run the job, if you see the dump file in your bucket after this you will need to take a look at your bucket policy to give access to your kube. — Chris32
– Chris32, Commented Oct 17, 2019 at 7:43

guillaume blaquiere · Accepted Answer · 2019-10-17 09:33:47Z

1

You don't copy the right file:

mysqldump --u root --p"root" homestead > trydata.sql; gcloud config set project thereport; gcloud auth activate-service-account --key-file backup; gsutil cp /laravel.sql gs://backup-buck

answered Oct 17, 2019 at 9:33

guillaume blaquiere

76.6k3 gold badges65 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

guillaume blaquiere Over a year ago

To be sure that you get the same file, in the same directory, try with this (absolute path to trydata.sql file because you copy the file with this path) ` mysqldump --u root --p"root" homestead > /trydata.sql;`

Saya Kasta Over a year ago

i have done everything as per suggestion, still not able to take backup.

Collectives™ on Stack Overflow

Unable to create a MySQL database backup in GCP storage

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related