MySQL Backup using mysqldump

Create file

Add

Make it executable

Set cronjob

Backing up to Google Cloud Storage

Add following line to end of the script. Make sure you have Installed Google Cloud SDK and configured gsutil.

Create a Googe Cloud Storage bucket of type Nearline. Set life cycle policy to delete files after 30 days.

backup