Revision 13185
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/lib/sh/db.sh | ||
|---|---|---|
| 1 | 1 |
#!/bin/bash -e |
| 2 | 2 |
. "$(dirname "${BASH_SOURCE[0]}")"/util.sh
|
| 3 |
.rel sync.sh |
|
| 3 | 4 |
|
| 4 | 5 |
if self_not_included; then |
| 5 | 6 |
|
| ... | ... | |
| 244 | 245 |
mysql_ctl() # usage: mysql_ctl {start|stop|restart|...}
|
| 245 | 246 |
{ echo_func; sudo service mysql "$@"; }
|
| 246 | 247 |
|
| 248 |
mysql_snapshot() # usage: live=1 [from=...] to=... mysql_snapshot |
|
| 249 |
{
|
|
| 250 |
echo_func; kw_params from to; : "${to:?}"
|
|
| 251 |
local from="${from-/var/lib/mysql/}";
|
|
| 252 |
|
|
| 253 |
mysql_ctl stop |
|
| 254 |
local_dir="$from" remote_url="$to" sudo upload |
|
| 255 |
mysql_ctl start |
|
| 256 |
} |
|
| 247 | 257 |
|
| 258 |
|
|
| 248 | 259 |
### PostgreSQL |
| 249 | 260 |
|
| 250 | 261 |
alias use_pg='declare prefix=pg_; import_vars; unset prefix' |
Also available in: Unified diff
lib/sh/db.sh: added mysql_snapshot()