Linux知识点

1. shell操作数据库

#!/bin/sh
HOSTNAME="192.168.119.80"                              #数据库信息  
PORT="3306" 
USERNAME="root" 
PASSWORD="123456"  
DBNAME="guesslike"                                        #数据库名称  
TABLENAME="guesslike_andr_0"                              #数据库中表的名称 
#创建数据库  
sql="insert into guesslike_andr_0(im,date, gldata) values('864783010132178','131119','jsonjson')"
mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} -e "${sql}"

2. scp 排除 先打包再拷贝再解压
<1. tar -czvvf adpushquartz.tar.gz adpushquartz/ --exclude=adpushquartz/log
<2. scp -r adpushquartz.tar.gz root@10.5.18.51:/opt/app/
<3. tar -xzvf adpushquartz.tar.gz

3.看连接数

netstat -ano |grep ':80'|grep EST|wc -l

4. 查看进程

ps -A -opid,stime,etime,args|grep java