I have a directory that
chmod +x backup.sh
chmod +x backup.sh
SHELL=/bin/sh
PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin
#!/bin/sh
#
dbhost=localhost
dbuser=root
dbpass='password123'
dbname=mydatabase
webrootdir=/var/www/joomla
tempdir=/usr/local/backups/anew
tarnamebase=backup
email=
confdir=/usr/local/scripts/ezu/functions.sh
attach=
. $confdir
motty said:Thanks for your reply Beastie, below is my crontab patch variable seems to be different than your suggestion. I changed it to your suggested variable but not success.
Code:SHELL=/bin/sh PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin
PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin
*/5 * * * * root /usr/local/scripts/octs/uzb.sh
sh -c "/usr/local/bin/mysqldump -u root -ppassword database1 > /usr/local/backups/test/backup-`date +%y%m%d`.sql"
df -k | nawk 'NR > 1 {
$1 = $1; printf "insert into df values ( \47%s\47,", h
for (i = 0; ++i <=NF;)
printf "\47%s\47,", $i
print " current_timestamp );"
}' OFS=, h="SMS_JAR" |
mysql -h192.168.55.22 -uroot -prootp kpi
00 08 * * * /export/home/jinny/diskspace.sh
SHELL=/bin/sh
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin
mysql_config_editor set --login-path=DBDescription --host=DB#.pair.com --user=DBUser --port=3306 --password
mysql_config_editor print --login-path=DBDescription
[DBDescription]
user = root
password = *****
host = localhost
port = 3306
#!/bin/sh
#Set paths
MYDUMP=/usr/local/bin/mysqldump
BACKUPDIR=/usr/local/www/apache24/data
MYGZIP=/usr/bin/gzip
MYFIND=/usr/bin/find
#Dump
$MYDUMP --login-path=DBDescription DBNAME > $BACKUPDIR/mysql-DBNAME.`date '+%d-%B-%Y--%Hh'`.sql
#GZIP the file
$MYGZIP $BACKUPDIR/mysql-DBNAME.`date '+%d-%B-%Y--%Hh'`.sql
# nano /etc/crontab
00 04 * * * root /usr/local/www/apache24/data/mybackup.sh