Forum debian-fr.org

/root/script/sauvegarde.sh

ls -l /root/script
-rw-r--r-- 1 root root 770 11 mai   23:09 sauvegarde.sh

/save/Zai1koi1

ls -l /save
drwx------ 2 root root 16384 10 mai   22:12 lost+found
drwxr-xr-x 2 root root  4096 11 mai   21:43 sauvegarde
drwx------ 2 root root  4096 11 mai   23:08 Zai1koi1

crontab -l
30 23 * * * root /root/script/sauvegarde.sh > /dev/null 2>&1

cat /var/log/cron.log
May 11 23:30:01 ns /USR/SBIN/CRON[6429]: (root) CMD (root /root/script/sauvegarde.sh > /dev/null 2>&1)
May 11 23:30:01 ns /USR/SBIN/CRON[6430]: (root) CMD (/usr/local/rtm/bin/rtm 49 > /dev/null 2> /dev/null)
May 11 23:30:01 ns /USR/SBIN/CRON[6427]: (CRON) error (grandchild #6429 failed with exit status 127)

root@ns:/usr/local/bin# ls -l
total 4
-rwxr-xr-x 1 root staff 770 12 mai   12:55 sauvegarde.sh

May 12 12:58:01 ns /USR/SBIN/CRON[27590]: (root) CMD (/usr/local/rtm/bin/rtm 49 > /dev/null 2> /dev/null)
May 12 12:58:01 ns /USR/SBIN/CRON[27591]: (root) CMD (root /usr/local/bin/sauvegarde.sh > /dev/null 2>&1)
May 12 12:58:01 ns /USR/SBIN/CRON[27588]: (CRON) error (grandchild #27591 failed with exit status 127)

#!/bin/bash

# Initialisation des variables
DATE=$(date "+%Y-%m-%d")
HEURE=$(date "+%H%M%S")
REP=/save/Zai1koi1
HOST=localhost
USER=root
PASSWORD=monmdp
DATABASES=`mysql --host=${HOST} --user=${USER} --password=${PASSWORD} -e 'SHOW DATABASES' | sed '1,1d'` # définition de la liste des bases
#duree de l'historique
KEEP=15       

# création du répertoire pour les backups du jour
mkdir $REP/$DATE

# supprime le  repertoire le plus vieux
ls -d $REP/2* | sort | head --lines=-$KEEP | xargs rm -rf

#Boucle de sauvegarde
for i in $DATABASES;
do
mysqldump --host=${HOST} --user=${USER} --password=${PASSWORD} --extended-insert --routines ${i} > ${REP}/${DATE}/${i}.sql
zip   ${REP}/${DATE}/${i}-${DATE}.zip     ${REP}/${DATE}/${i}.sql
rm ${REP}/${DATE}/${i}.sql
done

# Edit this file to introduce tasks to be run by cron.
#
# Each task to run has to be defined through a single line
# indicating with different fields when the task will be run
# and what command to run for the task
#
# To define the time you can provide concrete values for
# minute (m), hour (h), day of month (dom), month (mon),
# and day of week (dow) or use '*' in these fields (for 'any').#
# Notice that tasks will be started based on the cron's system
# daemon's notion of time and timezones.
#
# Output of the crontab jobs (including errors) is sent through
# email to the user the crontab file belongs to (unless redirected).
#
# For example, you can run a backup of all your user accounts
# at 5 a.m every week with:
# 0 5 * * 1 tar -zcf /var/backups/home.tgz /home/
#
# For more information see the manual pages of crontab(5) and cron(8)
#
# m h  dom mon dow   command
58 12 * * * root /usr/local/bin/sauvegarde.sh > /dev/null 2>&1

58 12 * * * /usr/local/bin/sauvegarde.sh > /dev/null 2>&1

58 12 * * * cd /usr/local/bin ; ./sauvegarde.sh > /dev/null 2>&1

ricardo@serveur:~$ ls -al /var/www
total 68
drwxr-x--- 12 root www-data 4096 14 juil.  2011 .
drwxr-xr-x 14 root root     4096 28 mars   2011 ..
-rw-r-----  1 root www-data 1037 24 nov.   2010 404.html
drwxr-x---  3 root www-data 4096  6 août   2011 aviculture
drwxr-x---  3 root www-data 4096  6 août   2011 delires
drwxr-x---  3 root www-data 4096  6 août   2011 etabli

404.html - aviculture - delires et etabli