karavan
Advanced Member | Редактировать | Профиль | Сообщение | ICQ | Цитировать | Сообщить модератору
#!/bin/bash
host=""
WEBdirectory=""
mysqlUser=""
mysqlDB=""
characterSet=""
mysqlPassword=""
path_to_archives=""
eXclude=""
cd $(dirname $(readlink -e $0))
. variables.txt
DATE=$(/bin/date +%Y.%m.%d)
randFName=$(</dev/urandom tr -dc A-Za-z0-9 | head -c 8)
ssh $host "cd $WEBdirectory && rm -rf ./*.sql"
ssh $host "cd $WEBdirectory && mysqldump --user=${mysqlUser} -p${mysqlPassword} --default-character-set=${characterSet} --lock-tables ${mysqlDB} > ./mysqldump_${DATE}_${randFName}.sql"
ssh $host "cd $WEBdirectory && tar ${eXclude} -c ./| bzip2 -9z" > ${path_to_archives}/${host}_${DATE}_${randFName}.tar.bz2
ssh $host "cd $WEBdirectory && rm -rf ./mysqldump_${DATE}_${randFName}.sql"
i=0;
for item in $(ls -t ${path_to_archives}); do
if [ $i -gt 60 ]; then
rm -f ${path_to_archives}/${item};
fi
let "i++"
done
exit 0 |
Всего записей: 1962 | Зарегистр. 02-12-2011 | Отправлено: 23:07 17-05-2017 | Исправлено: karavan, 23:34 17-05-2017 |
|
