dump database and upload to GCS

backup.py

import os
from google.cloud import storage
from datetime import  datetime

# backup database
date = datetime.now().strftime("%Y-%m-%d")
base_dir = "/var/www/sophie/"
folder_name = "backup/"
filename = date + ".sql"

# The password of mysql root user is `12345`. `hallai` is the DB I want to backup.
command = "mysqldump -uroot -p12345 hallai > " + base_dir + folder_name + filename
os.system(command)

# upload to google cloud storage
client = storage.Client.from_service_account_json(base_dir + "credentials_gcs.json")
bucket = client.get_bucket('taipei_medical')   # my bucket name
blob = bucket.blob(folder_name + filename)     # I want to store the backup file in `backup` folder on GCS
blob.upload_from_filename(base_dir + folder_name + filename)