1
#!/Users/gmax/usr/local/bin/bash
3
#-----------------------------------------
4
SBDIR="/Users/gmax/sandboxes/msb_5_1_34"
6
#-----------------------------------------
9
# attempt to drop databases gracefully
13
for D in `echo "show databases " | ./use -B -N | grep -v "^mysql$" | grep -v "^information_schema$"`
15
echo 'drop database `'$D'`' | ./use
17
VERSION=`./use -N -B -e 'select version()'`
18
if [ `perl -le 'print $ARGV[0] ge "5.1" ? "1" : "0" ' "$VERSION"` = "1" ]
20
./use -e "truncate mysql.general_log"
21
./use -e "truncate mysql.slow_log"
27
rm -f data/`hostname`*
32
rm -f data/*relay-bin*
40
# remove all databases if any
42
for D in `ls -d data/*/ | grep -w -v mysql `