[root@db01 scripts]# cat fenbiao.sh

#!/bin/bash

#. /etc/rc.d/init.d/functions

start_db () {

if [ -e /etc/init.d/mysqld ]

then

    M_ST=$(/etc/init.d/mysqld status|awk '{print $3}')

    [ "${M_ST}" != "running" ]&&/etc/init.d/mysqld start

        sleep

        M_ST=$(/etc/init.d/mysqld status|awk '{print $3}')

        [ "${M_ST}" != "running" ]||exit

else

    echo  "start up file not exits,error"

        exit 

fi

}

dump_db () {

for db in `mysql -u root -poldboy123 -e "show databases;"|sed '1,2d'`

do

    for tb in `mysql -u root -poldboy123 -e "use $db;show tables;"|sed '1d'`

    do

         mkdir -p /server/dbbackup/$(date +%F)/$db

         /application/mysql/bin/mysqldump  --lock-tables=  -uroot -poldboy123  $db  $tb  >/server/dbbackup/$(date +%F)/${db}/${db}.${tb}$(date +%F).sql

    done

done

}

main() {

  M_ST=$(/etc/init.d/mysqld status|awk '{print $3}')

  if [ "${M_ST}" != "running" ]

  then

    echo "to start db"

    start_db

        sleep 

  fi

   dump_db >/dev/null >&

}

main

[root@db01 scripts]# cat fenku_backup.sh

#!/bin/bash

#gaobo  40team  @qq.com

#

#

#对数据库进行启动二次检查

function checkdb() {

  if [ -f /etc/init.d/mysqld ]

    then

    db_stat=$(/etc/init.d/mysqld status|awk '{print $3}')

    if [ "${db_stat}" != "running" ]

        then

        /etc/init.d/mysqld start

        sleep

        db_stat=$(/etc/init.d/mysqld status|awk '{print $3}')

        echo $db_stat

        [ "${db_stat}" != "running" ] && /etc/init.d/mysqld start

        sleep

        db_stat=$(/etc/init.d/mysqld status|awk '{print $3}')

                echo $db_stat

        [ "${db_stat}" != "running" ] && {

            echo "启动失败,请检查数据库"

            exit ;

        }

    fi

  else

    echo "数据库启动文件不存在请检查"

  fi

}

# 按照库进行分库不同的文件备份

# -e 不进入数据库执行命令

function seperate_db() {

for db in  $(mysql -uroot -poldboy123 -e "show databases;"|awk 'NR>1{print $0}')

do

    /application/mysql/bin/mysqldump  --lock-tables= -uroot -poldboy123  $db >/server/dbbackup/$(date +%F)/${db}$(date +%F).sql

done

}

#按照数据库的表为不同文件进行备份

#

seperate_tb () {

for db in `mysql -u root -poldboy123 -e "show databases;"|sed '1,2d'`

do

    for tb in `mysql -u root -poldboy123 -e "use $db;show tables;"|sed '1d'`

    do

         mkdir -p /server/dbbackup/$(date +%F)/$db

         /application/mysql/bin/mysqldump  --lock-tables=  -uroot -poldboy123  $db  $tb  >/server/dbbackup/$(date +%F)/${db}/${db}.${tb}$(date +%F).sql

    done

done

}

function main() {

    checkdb

    case $ in

        seperate_db)

        seperate_db  >/dev/null >&

        ;;

        seperate_tb)

        seperate_tb  >/dev/null >&

        ;;

        *)

        echo "Usage fenku_backup.sh  {seperate_db|seperate_tb}"

        ;;

    esac

}

main $