source: trunk/MagicSoft/Mars/datacenter/scripts/budb@ 9439

Last change on this file since 9439 was 9291, checked in by snruegam, 16 years ago
*** empty log message ***
  • Property svn:executable set to *
File size: 2.3 KB
Line 
1#!/bin/bash
2#
3# ========================================================================
4#
5# *
6# * This file is part of MARS, the MAGIC Analysis and Reconstruction
7# * Software. It is distributed to you in the hope that it can be a useful
8# * and timesaving tool in analysing Data of imaging Cerenkov telescopes.
9# * It is distributed WITHOUT ANY WARRANTY.
10# *
11# * Permission to use, copy, modify and distribute this software and its
12# * documentation for any purpose is hereby granted without fee,
13# * provided that the above copyright notice appear in all copies and
14# * that both that copyright notice and this permission notice appear
15# * in supporting documentation. It is provided "as is" without express
16# * or implied warranty.
17# *
18#
19#
20# Author(s): Daniela Dorner 10/2006 <mailto:dorner@astro.uni-wuerzburg.de>
21#
22# Copyright: MAGIC Software Development, 2000-2008
23#
24#
25# ========================================================================
26#
27# This script backups the Magic Database.
28# In addition it writes out the commands how to create the database.
29#
30
31today=`date +%F`
32olday=`date +%F --date="-30day"`
33
34source `dirname $0`/sourcefile
35printprocesslog "INFO starting $0"
36
37set -C
38
39path=/home/`whoami`/budb
40logpath=$path/log
41mkdir -pv $logpath
42logfile=$logpath/budb$today.log
43oldlog=$logpath/budb$olday.log
44file=$path/alldatabases
45end=.sql.bz2
46zipfile=$file$today$end
47oldzip=$file$olday$end
48
49dbname=MyMagic
50command=$path/Create$dbname$today.txt
51oldcommand=$path/Create$dbname$olday.txt
52
53date > $logfile
54getdbsetup
55
56echo "today: $today" >> $logfile 2>&1
57echo "date to remove: $olday" >> $logfile 2>&1
58
59echo "removing old files..." >> $logfile 2>&1
60rm -v $oldzip >> $logfile 2>&1
61rm -v $oldlog >> $logfile 2>&1
62rm -v $oldcommand >> $logfile 2>&1
63
64echo "writing all databases to $zipfile..." >> $logfile 2>&1
65
66# complete databases
67if ! mysqldump --host=$ho --all-databases -u dump | bzip2 -9 -c >| $zipfile 2>> $logfile
68then
69 printprocesslog "ERROR mysqldump failed "
70 echo "ERROR mysqldump failed " >> $logfile 2>&1
71fi
72echo "writing create commands to $command..." >> $logfile 2>&1
73# commands to create MyMagic
74if ! mysqldump --host=$ho --database $dbname -u dump --no-data >| $command 2>> $logfile
75then
76 printprocesslog "ERROR mysqldump failed "
77 echo "ERROR mysqldump failed " >> $logfile 2>&1
78fi
79
80finish >> $logfile 2>&1
81
Note: See TracBrowser for help on using the repository browser.