数 据库表备份脚本

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



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