How can I automate my database backups?

How can I automate my database backups?

You can automate database backups using scripts or tools like cron jobs for scheduling. What database are you using?

I'm using MySQL. Can you give me a sample script?

Sure! Here's a simple bash script:

#!/bin/bash

# Variables
DB_USER='your_username'
DB_PASS='your_password'
DB_NAME='your_database'
BACKUP_DIR='/path/to/backup'

# Create backup
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_DIR/backup_$(date +%F).sql

You can schedule this script with a cron job.

How do I set up a cron job for this script?

You can set up a cron job by running crontab -e and adding a line like:

0 2 * * * /path/to/your/script.sh

This will run the script every day at 2 AM.