GitHub Action for mysqldump

backup-mysql.yml

name: backup-mysql
on:
  schedule:
    # Run at 7:00 UTC every day
    - cron: "0 7 * * *"
jobs:
  run_mysqldump:
    runs-on: ubuntu-latest
    steps:
      - name: Dump database
        env:
          MYSQL_PWD: ${{ secrets.MYSQL_PWD }}
        run: |
          mysqldump \
            -u my-user \
            -h some.host.example.com \
            -P 4242 \
            --verbose \
            very_important_database \
            | bzip2 -c > latest.sql.bz2
      - name: Archive database dump
        uses: actions/upload-artifact@v2
        with:
          name: latest.sql.bz2
          path: latest.sql.bz2