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