Автоматизатор

export USER=loginname PASSWORD=password HOST=host
( mysql -u$USER -p$PASSWORD $HOST -Bse 'show tables;' ) | ( while read tb; do mysql -u$USER -p$PASSWORD $HOST -Bse "repair table $tb"; done )

##
# replace node value in sly xml
#     <context-param>
#         <param-name>$2</param-name>
#         <param-value>Some Old Value</param-value>
#     </context-param>
# @param $1 filename
# @param $2 param name
# @param $3 param value to set
# used if there is no xpath tool in system
set_param_value() {
    local new_value="$3"
    local webxml="$1"
    # TODO find backup destination name
    local old="$webxml".tmp
    local catch_next_tag=0
 
    if [ ! -w "$webxml" ]; then
        echo -e "${ERR}$webxml is not writable! Failed!${N}"
        return 1;
    fi