MySQL Backups: Uploading to Wasabi

Wasabi supports MySQL backups.

1. You can use the following code to back up any entity in mySQL.

   mysqldump -u [user] \
                    -p [password] \
                    -h [host] \
                    --single-transaction \
                    --routines --triggers \
                    --all-databases
   
       

2. After the script runs, save the output from stdout to a file:

   mysqldump -u [user] [...] | gzip > mysql_backup.sql.gz

3. Upload the file.

Wasabi supports the Amazon CLI, which can be used for such uploads. To set it up, refer to AWS CLI With Wasabi.