blob: 2cd86fbb2973f68cb461cbf41c618d6dffeda66d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
#!/bin/sh
# Initialization
PATH_TO_FILE=${PATH_TO_FILE:-<%= blog_db_backupdir %>}
[ ! -f $PATH_TO_FILE/count ] && echo 0 > $PATH_TO_FILE/count
COUNT=$(cat "$PATH_TO_FILE/count")
# Backup each locale DB
for locale in de el en es fr it nl pl pt ro ru tr
do
if [ ! -d $PATH_TO_FILE/$locale ]
then
/bin/mkdir $PATH_TO_FILE/$locale
fi
/usr/bin/mysqldump --add-drop-table -h localhost blog_$locale | bzip2 -c > $PATH_TO_FILE/$locale/mageia_$locale-$COUNT.bak.sql.bz2
done
# Check count file to have a week of backup in the directory
if [ $COUNT -ne 6 ]
then
COUNT=$(expr $COUNT + 1)
else
COUNT="0"
fi
echo $COUNT > $PATH_TO_FILE/count
|