BASH - "Automatic database backup"

#!/bin/bash
cd /home/USERNAME/backups/
mkdir mysql
suffix=$(date +%y%m%d)
mysqldump --opt -u SQLUSERNAME -pSQLPASSWORD -h SQLHOSTNAME SQLBDNME > mysql/backup.$suffix.sql
tar -zcf archives/mysql_backup.$suffix.tar mysql/*
rm -r mysql/

Kashub's Code Barn - "Automatic database backup"

podświetlone jako bash (dodał(a) MySQL via CronTab @ 2009-07-15 09:00:00)