Implementing Automated Snapshot Scripts

To establish a reliable data retention workflow on Linux infrastructure, configure a shell script to handle the export logic and deploy it via the system schedluer. The process involves defining connection parameters, generating the dump files, and ensuring the scheduled service can execute the command.

First, prepare the configuration file containing database credentials and target storage paths. Use environment-style varaibles for flexibility and clarity.

# Configuration Variables
MYSQL_USERNAME="root_user"
MYSQL_PASSWORD="complex_password_123"
DB_NAME="application_db"
BACKUP_ROOT="/var/backups/mysql_snapshots"
TIMESTAMP=$(date "+%F_%H%M")

# Generate uncompressed SQL dump
mysqldump -u"$MYSQL_USERNAME" -p"$MYSQL_PASSWORD" "$DB_NAME" \
  > "${BACKUP_ROOT}/${DB_NAME}_${TIMESTAMP}.sql"

For optimized storage usage, pipe the standard output directly into a compression utility such as gzip during execution.

mysqldump -u"$MYSQL_USERNAME" -p"$MYSQL_PASSWORD" "$DB_NAME" \
  | gzip > "${BACKUP_ROOT}/${DB_NAME}_${TIMESTAMP}.sql.gz"

Ensure the specified destination directory exists prior to running the script and verify that the user account has write permissions. Validate functionality manually by executing the script absolute path to confirm file creation. Once tested successfully, assign executable permissions to allow automatic invocation.

chmod +x /usr/local/bin/mysql_backup.sh

Utilize the crontab utility to define recurring execution schedules. Edit the task list using crontab -e. Each line defines a job based on minute, hour, day-of-month, month, and day-of-week fields. Useful maintenance commands include:

• View current entries: crontab -l
• Delete all scheduled jobs: crontab -r

Standard terminal editors such as vim or nano are employed to modify these configuration files. When using vim, transition to insert mode before typing changes, then save and exit using :wq from normal mode. Always ensure the script directory permissions restrict unauthorized access to the stored database passwords.