柳暗花明笔记

    shell empty mysql db

    所属分类:[ linux&mysql ] 猫哲学家 发表于:2012-08-10 22:33 浏览:455

    #!/bin/bash
    MUSER="$1"
    MPASS="$2"
    MDB="$3"
     
    # Detect paths
    MYSQL=$(which mysql)
    AWK=$(which awk)
    GREP=$(which grep)
     
    if [ $# -ne 3 ]
    then
        echo "Usage: $0 {MySQL-User-Name} {MySQL-User-Password} {MySQL-Database-Name}"
        echo "Drops all tables from a MySQL"
        exit 1
    fi
     
    TABLES=$($MYSQL -u $MUSER -p$MPASS $MDB -e 'show tables' | $AWK '{ print $1}' | $GREP -v '^Tables' )
     
    for t in $TABLES
    do
        echo "Deleting $t table from $MDB database..."
        $MYSQL -u $MUSER -p$MPASS $MDB -e "drop table $t"

    标签: mysql 
    上一编文章 10 Ways to Automatically & Manually Backup MySQL Database 下一编文章 我安装mysql不成功的原因 ldconfig几个需要注意的地方
    最近文章
    发表评论