Cron deamon
Peter Novak
novak71 at post.sk
Thu Jun 2 09:53:43 CEST 2005
Zdravim Vas,
potrebujem cez cron spustat zalohovaci skript. Manualne spustenie skriptu
funguje v poriadku, ale spustenie cez cron nefunguje, konkretne "mysqldump".
********** prava skriptu :
-rwx------ 1 root wheel 685 2 jún 08:39 zalohujdb.sh
********** doplnene do /etc/crontab na zalohu raz za den vzdy o 10.00
1 10 * * * root /usr/backup/zalohujdb.sh
********** skript "zalohujdb.sh":
#!/bin/sh
MENO_SUBORU=db_`date +%d%m%y`
cd /usr/backup
echo ====== Zalohujem databazu =======
mysqldump -uoperator -pxxxxxxx obchod > $MENO_SUBORU.sql
echo ====== Zipujem databazu =======
tar -zcvf $MENO_SUBORU.tgz $MENO_SUBORU.sql
echo ====== Mazem .sql subor =======
rm $MENO_SUBORU.sql
echo ====== Odpajam CD =======
umount /cdrom
echo ====== Vytvorim iso subor z tgz =========
mkisofs -o $MENO_SUBORU.iso -J -R $MENO_SUBORU.tgz
echo ====== Napalujem data v multisession mode =========
burncd -m -f /dev/acd0 -s 10 data $MENO_SUBORU.iso fixate
echo ====== Mazem .iso subor =======
rm $MENO_SUBORU.iso
********** Vysledok zalohy odoslanaj cronom na e-mail :
====== Zalohujem databazu =======
mysqldump: not found
====== Zipujem databazu =======
tar: db_020605.sql: Could not stat: No such file or directory
====== Mazem .sql subor =======
rm: db_020605.sql: No such file or directory
====== Odpajam CD =======
umount: /cdrom: not a file system root directory
====== Vytvorim iso subor z tgz =========
mkisofs: not found
====== Napalujem data v multisession mode =========
burncd: ioctl(CDRIOCWRITESPEED): Input/output error
====== Mazem .iso subor =======
rm: db_020605.iso: No such file or directory
====== Pripajam CD ============
cd9660: /dev/acd0: Input/output error
Preco cron nenasiel mysqldump ?
Dakujem
________
Vsetci sa raz zideme na http://blog.sme.sk
More information about the Users-l
mailing list