1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
#!_BINBASH_
__LICENSE__
#-----------------------------------------
SBDIR="_HOME_DIR_/_SANDBOXDIR_"
. "$SBDIR/sandbox_env"
#-----------------------------------------
cd $SBDIR
#
# attempt to drop databases gracefully
#
if [ -f $PIDFILE ]
then
for D in `echo "show databases " | ./use -B -N | grep -v "^mysql$" | grep -v "^information_schema$"`
do
echo 'drop database `'$D'`' | ./use
done
VERSION=`./use -N -B -e 'select version()'`
if [ `perl -le 'print $ARGV[0] ge "5.1" ? "1" : "0" ' "$VERSION"` = "1" ]
then
./use -e "truncate mysql.general_log"
./use -e "truncate mysql.slow_log"
fi
fi
./stop
#./send_kill
rm -f data/`hostname`*
rm -f data/log.0*
rm -f data/*.log
rm -f data/falcon*
rm -f data/mysql-bin*
rm -f data/*relay-bin*
rm -f data/ib*
rm -f data/*.info
rm -f data/*.err
rm -f data/*.err-old
# rm -rf data/test/*
#
# remove all databases if any
#
for D in `ls -d data/*/ | grep -w -v mysql `
do
rm -rf $D
done
mkdir data/test
|