53 lines
903 B
Bash
53 lines
903 B
Bash
#!/usr/bin/env bash
|
|
|
|
# TODO:
|
|
# - Проверка существования БД
|
|
|
|
db_connect() {
|
|
export DB_CONNECTION="-h ${DBHOST} -u ${DBUSER} ${DBTABLE}"
|
|
|
|
cat > ~/.my.cnf << EOF
|
|
[mysql]
|
|
user=${DBUSER}
|
|
password=${DBPASS}
|
|
|
|
[mysqldump]
|
|
user=${DBUSER}
|
|
password=${DBPASS}
|
|
|
|
column-statistics=0
|
|
EOF
|
|
|
|
chmod 600 ~/.my.cnf
|
|
}
|
|
|
|
db_drop() {
|
|
[[ -z "${DB_CONNECTION}" ]] && db_connect
|
|
|
|
mysql ${DB_CONNECTION} -e "drop database ${DBTABLE}"
|
|
}
|
|
|
|
db_backup() {
|
|
[[ -z "${DB_CONNECTION}" ]] && db_connect
|
|
|
|
mysqldump --routines ${DB_CONNECTION} | gzip > ${ARCHIVE}
|
|
}
|
|
|
|
db_restore() {
|
|
[[ -z "${DB_CONNECTION}" ]] && db_connect
|
|
|
|
mysql ${DB_CONNECTION} < ${ARCHIVE}
|
|
}
|
|
|
|
db_create() {
|
|
# [[ -z "${DB_CONNECTION}" ]] && db_connect
|
|
|
|
mysql -h ${DBHOST} -u ${DBUSER} -e "create database if not exist ${DBTABLE} charset utf8"
|
|
}
|
|
|
|
db_isExist() {
|
|
[[ -z "${DB_CONNECTION}" ]] && db_connect
|
|
|
|
false
|
|
}
|