backup-db.sh

#!/bin/bash
FNAME="$(date +"%Y_%m_%d_%H_%M_%S").dump"
/opt/homebrew/bin/mysqldump --port=3306 --host=127.0.0.1 \
                            -u $your_username -p$your_password $your_database_name > $FNAME
gzip $FNAME

# Then, you can add a cron job to run this script every day at 3am:

# 0 3 * * * /path/to/backup-db.sh

# restore db
# gzcat BACKUP_FILE_GZIP | mysql --port=3306 --host=127.0.0.1 -u $your_username -p $your_database_name