#!/bin/bash
# sh install-mysql-data.sh
# ---------------------------------------------------------
source /etc/profile
mysql_user=root
mysql_password=root
MYSQL_BACK_DIR=/data/mysql/backup
MYSQL_INSTALL_DIR=/data/mysql/app
for file in *.sql
do
	database="${file%.*}"
    echo "crate database: $database"
	mysql -h localhost -u$mysql_user -p$mysql_password -e "CREATE DATABASE \`$database\`"
  	mysql -h localhost -u$mysql_user -p$mysql_password -e "use \`$database\`; source $file"
	# 添加自动备份
	cron_task="00 3 * * * sh $MYSQL_INSTALL_DIR/back.sh localhost 3306 $mysql_user $mysql_password $database $MYSQL_BACK_DIR"
	echo "${cron_task}"
	sudo echo "${cron_task}" >> /var/spool/cron/crontabs/root
	chmod 600 /var/spool/cron/crontabs/root
done