#!/bin/bash
# homestead 本地环境
#host='127.0.0.1'
#user_name='homestead'
#password='secret'
#database='chef_ysc_server'

# 预生产服务器环境
host='pc-bp1r2721015mq4z40.mysql.polardb.rds.aliyuncs.com'
user_name='betauser'
password='L223IqMnBGwHYBszkk'
database='beta_chef_ysc_server'

# 测试服务器环境
#host='192.168.1.111'
#user_name='chef'
#password='zdsecret'
#database='chef_ysc_server'

if [ $1 ]; then
	user_name=$1
else
	echo "use default database user name $user_name"
fi

if [ $2 ]; then
	password=$2
else
	echo "use default database password $password"
fi

if [ $3 ]; then
	database=$3
else
	echo "use default database name $database"
fi

cat > ../database/store-backup/store.sql << EndOfTruncate
  truncate yoshop_store_api;
  truncate yoshop_store_menu;
  truncate yoshop_store_menu_api;
EndOfTruncate

mysqldump -h$host -u$user_name -p$password --no-create-db --no-create-info --skip-extended-insert $database --tables yoshop_store_api yoshop_store_menu yoshop_store_menu_api >> ../database/store-backup/store.sql