参考
手順
- バッチを配置
sudo mv /var/local/backup_table_test.sh backup /usr/local/bin/
※permission は644
- add permission
sudo chmod 744 /usr/local/bin/backup_table_test.sh
- confirm permission
ll /usr/local/bin/backup_table_test.sh
-rwxr--r-- 1 root staff 754 10月 4 15:36 /usr/local/bin/backup_table_test.sh*
- create log directory
※デフォルトは/var/log/syslog (ubuntu)
sudo mkdir /var/log/cron
- create backup directory
sudo mkdir /usr/local/bin/backup
- cron setting
sudo にしないとrootで設定しないので権限エラーになる
sudo crontab -e
分 時 日 月 曜日 command
ex)
* 10 * * * sudo /usr/local/bin/backup_table_test.sh > /var/log/cron
- test cron
毎時2分にセット
25 * * * * sudo /usr/local/bin/backup_table_test.sh > /var/log/cron
- confirm cron
crontab -l
25 * * * * sudo /usr/local/bin/backup_table_test.sh > /var/log/cron
- confirm exec
ll /usr/local/bin/backup
-rw-r--r-- 1 root root 3303 10月 4 16:25 client_20131004_162501.sql
-rw-r--r-- 1 root root 12311 10月 4 16:25 project_20131004_162501.sql
ll /var/log/cron/
-rw-r--r-- 1 root root 17 10月 4 16:25 backup.log
- cron setting
sudo crontab -e
* 10 * * * sudo /usr/local/bin/backup_table_test.sh > /var/log/cron/backup.log