全部博文(362)
发布时间:2013-05-04 14:08:17
#!/bin/bashconndate=`date +%Y-%m-%d_%H%M`connum=$(netstat -anp | grep 192.168.1.2 | wc -l)if [[ $connum -gt 0 ]]thennetstat -anp | grep 192.168.1.2 >> /opt/conn/conn_${conndate}.txt.........【阅读全文】
发布时间:2013-05-04 14:01:49
mysql -uroot -p123456 -e "use information_schema;select concat('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' ENGINE = InnoDB;') from TABLES where TABLE_SCHEMA like 'xxxdb_%' and ENGINE != 'InnoDB';"......【阅读全文】