mysql数据库多表备份及excel表格导出脚本编写

#!/bin/sh

# Database info
DB_USER="root"
DB_PASS="min"
DB_HOST="localhost"
DB_NAME="product"
# 数据库表
TABLE1="attribute_name"
TABLE2="attribute_value"
DB_TABLE=$TABLE1 $TABLE2

# Others vars
BIN_DIR="/usr/bin"            #the mysql bin path
BCK_DIR="/mnt/mysqlBackup"    #the backup file directory
DATE="`date +%Y-%m-%d`"
DB_PATH=$BCK_DIR/$DATE
# 打印存储路径
echo $DB_PATH
# 判断路径是否存在
if [ ! -d $DB_PATH ];then
echo $DB_PATH
mkdir $DB_PATH
chmod -R 777 $DB_PATH
else
echo $DB_PATH
rm -rf $DB_PATH
mkdir $DB_PATH
chmod -R 777 $DB_PATH
fi

# TODO
# 备份数据
$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS -h$DB_HOST $DB_NAME $DB_TABLE > $DB_PATH/db_data.sql

# 导出excel
mysql -u$DB_USER -p$DB_PASS $DB_NAME  -e "select * from $TABLE1 into outfile '$DB_PATH/$TABLE1.xls'";

mysql -u$DB_USER -p$DB_PASS $DB_NAME  -e "select * from $TABLE2 into outfile '$DB_PATH/$TABLE2.xls'";


#还原数据库
#用mysql-front导入前一天的 *.sql 文件即可恢复数据