blob: c3c370e694fbf060150883013daf05aefef0b92c (
plain)
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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
#!/bin/sh
set -e
MYSQLD=/usr/sbin/mysqld
DIR=`dirname $0`
DIR_FULL=`realpath $DIR`
ROOT=$DIR_FULL/mysqld
PID_FILE="$ROOT/mysql.pid"
MY_CNF="$ROOT/my.cnf"
PORT=3316
ROOTPW=123456
usage() {
me=`basename $0`
echo "$me: runs a local instance of mysql (on port $PORT)"
echo "Usage: $me <start|stop|restart|reload|status> - the usual"
echo "Usage: $me <init|clean> - install / remove the databases"
}
run_mysqld() {
$MYSQLD \
--defaults-file=$MY_CNF \
--basedir=$ROOT \
--pid-file=$PID_FILE \
--port=$PORT \
--socket=$ROOT/socket \
"$@"
}
run_mysql_upgrade() {
mysql_upgrade \
--defaults-file=$MY_CNF \
"$@"
}
init_mysql() {
me=`id -un`
mysql_install_db \
--defaults-file=$MY_CNF \
--basedir="$ROOT" \
--datadir="$ROOT/data" \
--port=$PORT \
--socket=$ROOT/socket \
--user="$me"
}
run_client() {
mysql \
--defaults-file=$MY_CNF \
--port=$PORT \
--socket=$ROOT/socket \
--user="root" \
"$@"
}
case "$1" in
start) shift; run_mysqld "$@" &;;
init) init_mysql;;
stop)
pid=`cat "$PID_FILE" 2>/dev/null`
if [ "$pid" ]; then
kill $pid
fi
;;
restart)
"$0" stop
#sleep 1
"$0" start
;;
reload) kill -HUP `cat "$PID_FILE"`;;
status)
if [ -f "$PID_FILE" ]; then
ps `cat "$PID_FILE"`
else
echo "Not running"
fi
;;
clean)
# TODO: stop? Check if we're alive?
rm -rf $ROOT/data/*
;;
client) shift; run_client "$@";;
*) usage; exit 1;;
esac
|