Linux Shell经典面试题(其五)

来源：互联网发布：js设置div内容颜色编辑：程序博客网时间：2024/04/30 04:51

Linux Shell经典面试题(其五)

参考：http://jin771998569.blog.51cto.com/2147853/1639712

1.如何实现对MySQL数据库进行分库备份，请用脚本实现。

############mysql的分库备份脚本mysql-differ-database-backups.sh 的脚本编写##############$ vi mysql-differ-database-backups.sh#!/bin/bashMYUSER=rootMYPASS=passwordSOCKET="/var/lib/mysql/mysql.sock"MYCMD="mysql -u$MYUSER -p$MYPASS"MYDUMP="mysqldump -u$MYUSER -p$MYPASS"BACKUP_DIR="/work/backup/mysql"for database in `$MYCMD -e "show database;"|sed '1,2d' | egrep -v "mysql|schema"`do    if [! -f $BACKUP_DIR/${database} ];then        mkdir -p $BACKUP_DIR/${database}    fi    $MYDUMP ${database} | gzip > $BACKUP_DIR/${database}_`date +%F`.tar.gzdone

2.如何实现对MySQL数据库进行分库加分表备份，请用脚本实现。

############mysql的分库+分表备份脚本mysql-differ-database-table-backups.sh 的脚本编写##############$ vi mysql-differ-database-table-backups.sh#!/bin/bashMYUSER=rootMYPASS=passwordSOCKET="/var/lib/mysql/mysql.sock"MYCMD="mysql -u$MYUSER -p$MYPASS"MYDUMP="mysqldump -u$MYUSER -p$MYPASS"BACKUP_DIR="/work/backup/mysql"for database in `$MYCMD -e "show database;"|sed '1,2d' | egrep -v "mysql|schema"`do    if [! -f $BACKUP_DIR/${database} ];then        mkdir -p $BACKUP_DIR/${database}    fi    $MYDUMP ${database} | gzip > $BACKUP_DIR/${database}_`date +%F`.tar.gz    for i in $database        do            tables=`$MYCMD -e "use $i;show tables;"|sed 1d`            for j in $tables                do                    MYDUMP   -B --databases $i --tables $j > $BACKUP_DIR/${i}-${j}-`date +%F`.sql                done        donedone

阅读全文

1 0