shell 脚本输出的系统信息写入mysql数据库

mysql>create table kk(Amount int,IPAddress varchar(20),InsertDatetime timestamp default current_timestamp);

mysql>load data local infile "/root/aa" into table kk fields terminated by ' ';



################################

#!/bin/sh

netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n | awk '{if($1 > 1) print $1,$2}' > /root/aa

inscript="load data local infile '/root/aa' into table kk fields terminated by ' ';"

mysql -u User -pPassword -DDatabase -e "${inscript}"

rm -f /root/aa

################################

chmod 755 mytest