设计便捷命令行工具列表

 

1, 上传文件命令：

　　文件+空格+[需要上传的文件的绝对路径]  [arg...]

　　./scp.mc.up.sh /Users/jerryxu/wwwroot/cache/server/backup/1115just4/run.sh

+ View Code?

1 2 3 4 5 6 7 8 9 10

count=1 while [ "$#" -ge "1" ];do echo "参数序号为 $count 是 $1" DATE=`date +%F | sed 's/-//g'``date +%T | sed 's/://g'`   scp -r -P 7822 $1 %Host%:/home/justuniq/mc_xu/up_file let count=count+1 shift done echo "执行完成！"

　　%Host% 主机

2, 下载文件命令

　　文件+空格+【服务器绝对路径] 【arg...】

　　./scp.mc.down.sh /home/justuniq/mc_xu/xu_sh_backup/justuniq_just4_20190119034902.sql

+ View Code?

1 2 3 4 5 6 7

count=1 while [ "$#" -ge "1" ];do     echo "参数序号为 $count 是 $1"     scp -r -P 7822 %Host%:$1 /Users/jerryxu/wwwroot/cache/server/backup     let count=count+1     shift done

　　

3, 导入SQL到数据库命令：

　　文件+空格+[需要导入的文件的绝对路径] [arg...]

　　./mysql_import.sh /Users/jerryxu/wwwroot/cache/server/backup/justuniq_just4_20190423100022.sql

+ View Code?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

count=1 while [ "$#" -ge "1" ];do echo "参数序号为 $count 是 $1" DATE=`date +%F | sed 's/-//g'``date +%T | sed 's/://g'`   var=$1   socket=/Applications/MAMP/tmp/mysql/mysql.sock   user=%用户名% password=%密码%   mycmd="mysql -u$user -p$password -S $socket"   $mycmd -e "drop database $(basename ${var} .sql)";   #创建数据库 $mycmd -e "create database $(basename ${var} .sql)";   $mycmd -e "show databases;"   #source $1 $mycmd -f "$(basename ${var} .sql)" -e "source $1" let count=count+1 shift done echo "执行完成！"

　　%用户名% %密码% 

 

4，数据库导出命令：

　　文件+空格+[数据库名称] [arg...]

　　/mysqldump.sh justuniq_just4_20190423100022

+ View Code?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

acount=1                                                                  while [ "$#" -ge "1" ];do                                                    echo "参数序号为 $count 是 $1"     DATE=`date +%F | sed 's/-//g'``date +%T | sed 's/://g'`       if [ -d "../xu_sh_backup" ];then     echo "文件夹存在"     else     mkdir ../xu_sh_backup     fi       mysqldump -uroot -proot $1 >../xu_sh_backup/$1"_"$DATE.sql     let count=count+1                                                        shift done echo "执行完成！"

　　

 5, iterm2 配置 ssh 文件

#!/usr/bin/expect -f
set port [端口]
set user [用户名]
set host [服务器地址]
set password [密码]
set timeout -1

spawn ssh -p $port $user@$host
expect "*assword:*"
send "$password\r"
interact
expect eof