#!/bin/bash
set -e

#目标服务器账号
#User=voion

#目标服务器数据库账号、密码、数据库名称
Mysql_name=meshmachine_meshma
Mysql_user=meshmachine_meshma
Mysql_pwd='4yK_9hKd(s0['
Mysql_sqlfile=meshmach_xinzhong15487.sql


#数据库恢复
Mysql_data=`mysql -u${Mysql_user} -p${Mysql_pwd} -e "use ${Mysql_name};show tables;";`
if [ "${Mysql_data}" == "" ];then
    echo "no tables;"
    mysql -u${Mysql_user} -p${Mysql_pwd} ${Mysql_name} < ${Mysql_sqlfile}
else
    echo "Database is not empty"
fi

#修改网站数据库配置

#cd /home/${User}/public_html/
#[ ! -d tmp ] && mkdir tmp && chown -R ${User}. tmp
#DB_file_1=data/conf/db.php
#DB_file_2=include/config.inc.php
#DB_file_3=data/config.php
#echo "/home/${User}/public_html/ && chown -R ${User}. ${DB_file_1} && chown -R ${User}. ${DB_file_2} && chown -R ${User}. ${DB_file_3}"
#echo "DB_NAME ${Mysql_name}"
#echo "DB_USER ${Mysql_user}"
#echo "DB_PWD ${Mysql_pwd}"
#[ ! -f ${DB_file} ] && echo "The database configuration file does not exist" && exit 1

#Mysql_user_old=`grep 'DB_USER' ${DB_file} | awk 'BEGIN{ FS="'\''"}{print $4}'`
#Mysql_name_old=`grep 'DB_NAME' ${DB_file} | awk 'BEGIN{ FS="'\''"}{print $4}'`
#Mysql_pwd_old=`grep 'DB_PWD' ${DB_file} | awk 'BEGIN{ FS="'\''"}{print $4}'`

#sed -ri "/DB_NAME/ s/${Mysql_name_old}/${Mysql_name}/" ${DB_file}
#sed -ri "/DB_USER/ s/${Mysql_user_old}/${Mysql_user}/" ${DB_file}
#sed -ri "/DB_PWD/ s/${Mysql_pwd_old}/${Mysql_pwd}/" ${DB_file}

#chown -R ${User}. ${DB_file}