| 1234567891011121314151617181920212223242526272829303132333435363738394041424344 |
- #!/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
|
