mysql 백업스케쥴링

$vi back.sh

#!/bin/sh

time=`date '+%Y%m%d%H%M'`
etc="etc"

cd /
backup_path ="/backup_path/"
cd $backup_path

mysqldump -u[userid] -p[userpwd] [dbname] > "$time.sql" --default-character-set=latin1 --set-charset 
find /backup_path/* -mtime +5 -exec rm -f {} ';

$chmod 700 back.sh

$crontab -e

00 05 * * * /path/backup.sh 

(새벽 5시 정각)

* --default-character-set=latin1 --set-charset 캐릭터셋 지정