[!^1-^127]
=COUNTIF(B:B,B1669)>1
142.54.172.2
putty
wget http://downloads.zend.com/optimizer/3.3.9/ZendOptimizer-3.3.9-linux-glibc23-x86_64.tar.gz
tar zxvf ZendOptimizer-3.3.9-linux-glibc23-x86_64.tar.gz
wget http://www.rarlab.com/rar/rarlinux-5.0.0.tar.gz
tar zxvf rarlinux-5.0.0.tar.gz
tar zxvf mysql-5.5.8-linux2.6-i686.tar.gz
tar zxvf cmake-2.8.4.tar.gz
tar zxvf safedogfwq_linux64.zip
cd rar
make
make install
三、rar命令语法
将/etc 目录压缩为etc.rar 命令为:
rar a /home/www/1/zhishu.rar /home/mysql/zhishu
将etc.rar 解压 命令为:
rar x etc.rar
unrar -e etc.tar
unzip
rar a zhanqun.rar /home/mysql/zhanqun
rar a aaf.rar /home/www/TaoKe/aaf
rar a nvzhuangweb.rar /home/www/nvzhuang
rar a nvzhuangmysql.rar /home/mysql/nvzhuang
unrar x s.rar
解压覆盖
unrar -o -d
unrar x -o -d 1n.rar /home/www/
假设一个文件路径为 /xxx/xdxs/ddd 要移动到目录/ssss
mv /xxx/xdxs/ddd /ssss
复制相同
cp /xxx/xdxs/ddd /ssss
如果要root权限
就是
sudo mv /xxx/xdxs/ddd /ssss
然后会提示你输入密码,直接输入密码回车就行。复制同理。
m
unrar x /home/1.rar /home/1/
unrar x /home/2.rar /home/2/ ok
unrar x /home/3.rar /home/3/ ok
unrar x /home/4.rar /home/4/ ok
unrar x /home/5.rar /home/5/ ok
unrar x /home/6.rar /home/6/ ok
unrar x /home/7.rar /home/7/ ok
unrar x /home/8.rar /home/8/ ok
unrar x /home/9.rar /home/9/ ok
unrar x /home/data.rar /home/10data/ ok
4 5 7
批量移动命令
mv /var/www/TaoKe/1/* /var/www/TaoKe/
mv /var/www/TaoKe/2/* /var/www/TaoKe
mv /home/1.rar /home/1/
mv /home/2.rar /home/1/
mv /home/3.rar /home/1/
mv /home/4.rar /home/1/
mv /home/5.rar /home/1/
mv /home/6.rar /home/1/
mv /home/7.rar /home/1/
mv /home/8.rar /home/1/
mv /home/9.rar /home/1/
mv /home/data.rar /home/1/
rm -r /home/1
rm -r /home/2
rm -r /home/3
rm -r /home/4
rm -r /home/5
rm -r /home/6
rm -r /home/7
rm -r /home/8
rm -r /home/9
rm -r /home/1
rm -r /home/1
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^timg([0-9]*)/([^>]+)$ seolei_img.php?p1=$1&p2=$2 [NC]
RewriteRule ^([0-9]*)/timg([0-9]*)/([^>]+)$ seolei_img.php?p1=$2&p2=$3&size=_$1x$1.jpg [NC]
RewriteRule ^b/timg([0-9]*)/([^>]+)$ seolei_img.php?p1=$1&p2=$2&size= [NC]
RewriteRule ^([0-9]*)/timages/([^>]+)$ seolei_img.php?p3=$2&size=_$1x$1.jpg [NC]
RewriteRule ^b/timages/([^>]+)$ seolei_img.php?p3=$1&size= [NC]
RewriteRule ^(.*)\/([0-9]+)\.htmnvzhuang/plus/view.php?typedir=$1&aid=$2
#RewriteRule ^(.*)list-([0-9]+)\.htmnvzhuang/plus/list.php?typedir=$1&tid=$2
#RewriteRule ^(.*)list-([0-9]+)-([0-9]+)\.htmnvzhuang/plus/list.php?typedir=$1&tid=$2&PageNo=$3
RewriteRule ^tags/(.*)/nvzhuang/tags.php?/$1
RewriteRule ^tags/nvzhuang/tags.php
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^.*$ seolei_key.php
删除文件命令
rm -r /home/www/TaoKe/cache
rm -r /home/www/Nvzhuang/xizhuang/
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
sudo /etc/init.d/mysql restart
passwd
/etc/init.d/redis-server stop
/etc/init.d/redis-server start
/etc/init.d/redis-server restart
Linux系统为Ubuntu
一、Start Apache 2 Server /启动apache服务
# /etc/init.d/apache2 start
or
sudo /etc/init.d/apache2 start
二、 Restart Apache 2 Server /重启apache服务
# /etc/init.d/apache2 restart
or
sudo /etc/init.d/apache2 restart
三、Stop Apache 2 Server /停止apache服务
# /etc/init.d/apache2 stop
or
sudo /etc/init.d/apache2 stop
方法其实很简单,有需要的同学可以备案一下。
extension=memcache.so
搜索文件
find / -name 'httpd.conf'
find / -name 'wap.php'
find / -name 'jquery.php'
批量删除同名文件
find . -name 'T-CAI' -maxdepth 10000 -exec rm -rf '{}' \;
安装:sudo apt-get install axel
一般使用:axel url(下载文件地址)
axel http://www.eastdaygam.com/k2k/1.rar
axel http://www.eastdaygam.com/k2k/2.rar
axel http://www.eastdaygam.com/k2k/3.rar
axel http://www.eastdaygam.com/k2k/4.rar
axel http://www.eastdaygam.com/k2k/5.rar
axel http://www.eastdaygam.com/k2k/6.rar
axel http://www.eastdaygam.com/k2k/7.rar
axel http://www.eastdaygam.com/k2k/8.rar
axel http://www.eastdaygam.com/k2k/9.rar
axel http://www.eastdaygam.com/k2k/data.rar
查看linux下用户组是哪个命令!
察看 /etc/group文件
用cat /etc/passwd |cut -f 1 -d :
chmod -R 777 /home/mysql/
chmod -R 777 /home/www/
chmod -R 777 /home/www/TaoKe/cache
chmod -R 777 /home/www/TaoKe/yttzb/
chmod -R 777 /home/mysql/Nvzhuang_gov
unrar x /home/3.rar /var/www/TaoKe
chmod -R 777 /home/www/Nvzhuang
chmod -R 777 /home/mysql/Nvzhuang_gov
unrar x /home/www/78.rar /home/www/
重启系统命令
reboot
查看磁盘使用情况
df -hl
df -h
du -h --max-depth=1 /var
改密码
passwd
查看CPU使用情况
cat /proc/interrupts
top
要安装任何软件可使用默认的方法 如 apt-get install 软件名
apt get install mysql
apt get install git
apt get install apache
apt-get install php5-gd
查看安全狗 查看、启动或停止服务。
cd /etc/safedog sdui
service safedog start
service safedog stop
查看内存使用情况
free
vmstat 1
释放内存
sudo sysctl -w vm.drop_caches=3
任务计划
vi /etc/crontab
0 0 * * * root sysctl -w vm.drop_caches=3
0 1 * * * root sysctl -w vm.drop_caches=3
0 2 * * * root sysctl -w vm.drop_caches=3
0 3 * * * root sysctl -w vm.drop_caches=3
0 4 * * * root sysctl -w vm.drop_caches=3
0 5 * * * root sysctl -w vm.drop_caches=3
0 6 * * * root sysctl -w vm.drop_caches=3
0 7 * * * root sysctl -w vm.drop_caches=3
0 8 * * * root sysctl -w vm.drop_caches=3
0 9 * * * root sysctl -w vm.drop_caches=3
0 10 * * * root sysctl -w vm.drop_caches=3
0 11 * * * root sysctl -w vm.drop_caches=3
0 12 * * * root sysctl -w vm.drop_caches=3
0 13 * * * root sysctl -w vm.drop_caches=3
0 14 * * * root sysctl -w vm.drop_caches=3
0 15 * * * root sysctl -w vm.drop_caches=3
0 16 * * * root sysctl -w vm.drop_caches=3
0 17 * * * root sysctl -w vm.drop_caches=3
0 18 * * * root sysctl -w vm.drop_caches=3
0 19 * * * root sysctl -w vm.drop_caches=3
0 20 * * * root sysctl -w vm.drop_caches=3
0 21 * * * root sysctl -w vm.drop_caches=3
0 22 * * * root sysctl -w vm.drop_caches=3
0 23 * * * root sysctl -w vm.drop_caches=3
0 0 * * * root rm -r /var/log/apache2/other_vhosts_access.log
0 1 * * * root cp -rf /home/mysql/nvzhuang /home/sql/nvzhuang
0 2 * * * root cp -rf /home/mysql/huangye /home/sql/huangye
0 3 * * * root cp -rf /home/mysql/chinanews /home/sql/chiannews
0 4 * * * root cp -rf /home/mysql/fendou /home/sql/fendou
0 5 * * * root cp -rf /home/mysql/zhishu /home/sql/zhishu
0 6 * * * root cp -rf /home/www/nvzhuang /home/page/nvzhuang
0 7 * * * root cp -rf /home/www/huangye8 /home/page/huangye8
0 8 * * * root cp -rf /home/www/chinanews /home/page/chiannews
0 9 * * * root cp -rf /home/www/fendou /home/page/fendou
0 10 * * * root cp -rf /home/www/zhishu /home/page/zhishu
编辑
vi /etc/php5/apache2/php.ini
机器上搜大于2G的文件
find / -size +2000000k
查看访问日志
tail -f /var/log/apache2/other_vhosts_access.log
删除空值行
delete from `data_content_2` where 标题='';
sudo ethstatus -i eth0
update t_tmall set PageUrl=concat('https://shopsearch.taobao.com/search?app=shopsearch&user_id=',PageUrl);
update t_tmall set PageUrl=id;
复制文件夹或文件
cp -rf
cp -rf /home/mysql/nvzhuang /root/nvzhuang_bak
pidfile /var/run/redis.pid
重命名文件
mv Nvzhuang nvzhuang
进入MYSQL
mysql -uroot -proot3306
查看进入那个数据庫
SELECT DATABASE();
2.1 将所有文档设置为“仅动态浏览”:
update dede_archives set ismake=-1
2.2 将所有栏目设置为“使用动态页”:
update dede_arctype set isdefault=-1
ubuntu 修改apache2 默认网站目录和默认主页文档
/etc/apache2/mods-available/dir.conf: DirectoryIndex index.html index.cgi index.pl index.php index.xhtml index.htm
set session query_cache_type = ON;
开启查询缓存
SHOW STATUS LIKE 'Qcache_hits';
UPDATE data_content_7y SET PageUrl = REPLACE(`PageUrl`, 'user_id=1', 'user_id=7');
UPDATE data_content_8y SET PageUrl = REPLACE(`PageUrl`, 'user_id=1', 'user_id=8');
UPDATE data_content_9y SET PageUrl = REPLACE(`PageUrl`, 'user_id=1', 'user_id=9');
UPDATE data_content_10y SET PageUrl = REPLACE(`PageUrl`, 'user_id=1', 'user_id=10');
刷新mysql 缓存
flush tables;
替换mysql 字段数据
UPDATE dede_arctype SET typedir = REPLACE(`typedir`, '{cmspath}/', '/')
UPDATE dede_arctype SET typedir = REPLACE(`typedir`, '/think', '/Think')
UPDATE dede_arctype SET namerule = REPLACE(`namerule`, '{aid}.html', '{aid}.htm')
UPDATE dede_arctype SET namerule2 = REPLACE(`namerule2`, '{page}.html', '{page}.htm')
UPDATE dede_archives SET shorttitle = REPLACE(`shorttitle`, 'pic.jpg', 'pic.jpg_310x310.jpg') WHERE INSTR(`shorttitle`,'pic.jpg_310x310.jpg') > 0
{aid}.html
UPDATE dede_addonarticle SET body = REPLACE(`body`, '未知', '')
UPDATE Job SET StartUrl = REPLACE(`StartUrl`, '<100', '<5');
UPDATE ecs_goods SET original_img = REPLACE(`original_img`, '460x460.jpg460x460.jpg', '460x460.jpg');
UPDATE ecs_goods SET goods_img = REPLACE(`goods_img`, '460x460.jpg460x460.jpg', '.460x460.jpg');
UPDATE ecs_goods SET goods_thumb = REPLACE(`goods_thumb`, '460x460.jpg460x460.jpg', '460x460.jpg');
加值到表字段后
UPDATE data_content_1555 SET PageUrl= CONCAT(PageUrl,'phpchina');
加值到表字段前
update t_tmall set PageUrl=concat('https://shopsearch.taobao.com/search?app=shopsearch&user_id=',PageUrl);
ID字段复制到PageUrl
update t_tmall set PageUrl=id;
update T_tmall set encryptedUserId=nick;
update data_content_1557 set PageUrl=concat('http://shop',PageUrl);
update data_content_1558 set PageUrl=concat('http://shop',PageUrl);
update data_content_1559 set PageUrl=concat('http://shop',PageUrl);
update data_content_1560 set PageUrl=concat('http://shop',PageUrl);
update data_content_1561 set PageUrl=concat('http://shop',PageUrl);
update data_content_1562 set PageUrl=concat('http://shop',PageUrl);
update data_content_1563 set PageUrl=concat('http://shop',PageUrl);
update data_content_1564 set PageUrl=concat('http://shop',PageUrl);
update data_content_1565 set PageUrl=concat('http://shop',PageUrl);
update data_content_1566 set PageUrl=concat('http://shop',PageUrl);
update data_content_1567 set PageUrl=concat('http://shop',PageUrl);
update data_content_1568 set PageUrl=concat('http://shop',PageUrl);
update data_content_1569 set PageUrl=concat('http://shop',PageUrl);
update data_content_1570 set PageUrl=concat('http://shop',PageUrl);
update data_content_1571 set PageUrl=concat('http://shop',PageUrl);
update data_content_1572 set PageUrl=concat('http://shop',PageUrl);
update data_content_1573 set PageUrl=concat('http://shop',PageUrl);
update data_content_1574 set PageUrl=concat('http://shop',PageUrl);
update data_content_1575 set PageUrl=concat('http://shop',PageUrl);
update data_content_1576 set PageUrl=concat('http://shop',PageUrl);
UPDATE data_content_1558 SET PageUrl = REPLACE(`PageUrl`, 'id=20', 'id=22');
UPDATE data_content_1559 SET PageUrl = REPLACE(`PageUrl`, 'id=20', 'id=23');
UPDATE data_content_1560 SET PageUrl = REPLACE(`PageUrl`, 'id=20', 'id=24');
UPDATE data_content_1561 SET PageUrl = REPLACE(`PageUrl`, 'id=20', 'id=25');
UPDATE data_content_1562 SET PageUrl = REPLACE(`PageUrl`, 'id=20', 'id=26');
UPDATE data_content_1563 SET PageUrl = REPLACE(`PageUrl`, 'id=20', 'id=27');
UPDATE data_content_1564 SET PageUrl = REPLACE(`PageUrl`, 'id=20', 'id=28');
update Taoke_tmall set encryptedUserId=nick;
删除大于id的数据
delete from data_content_1576 where id>=400000000;
UPDATE T_tmall
SET
encryptedUserId = LEFT(encryptedUserId, INSTR(encryptedUserId, '_') - 1)
WHERE
INSTR(encryptedUserId, '_') > 0;
删除空值行
delete from `data_content_2` where 标题='';
update ecs_goods SET goods_thumb=SUBSTRING(goods_thumb,1,case when LOCATE('"',goods_thumb)!=0 then LOCATE('"',goods_thumb)-1 ELSE LENGTH(`goods_thumb`) END);
update ecs_goods set `original_img` = left(`.gif`,length(`.gif`) - 1);
update ecs_goods set `goods_img` = left(`goods_img`,length(`.gif`) - 1);
update ecs_goods set `goods_thumb` = left(`goods_thumb`,length(`.gif`) - 1);
MySQL 最快速清空数据表数据的 SQL 语句
TRUNCATE TABLE dede_addonarticle
ALTER TABLE `dede_taglist` CHANGE `tag` `tag` VARCHAR( 255 );
ALTER TABLE `dede_archives` CHANGE `description` `description` VARCHAR( 1000 );
ALTER TABLE `T_tmall` CHANGE `encryptedUserId` `encryptedUserId` VARCHAR( 255 );
395G
cp -rf /home/mysql/chinanews/dede_taglist.MYI /home/mysql/fendou2/
cp -rf /home/mysql/chinanews/dede_taglist.MYD /home/mysql/fendou2/
cp -rf /home/mysql/chinanews/dede_taglist.frm /home/mysql/fendou2/
cp -rf /home/mysql/chinanews/dede_tagindex.MYI /home/mysql/fendou2/
cp -rf /home/mysql/chinanews/dede_tagindex.MYD /home/mysql/fendou2/
cp -rf /home/mysql/chinanews/dede_tagindex.frm /home/mysql/fendou2/
chmod -R 400 /home/www/zonghezixun
root@hostzj:~# chmod -R 400 /home/www/shishixinwen
root@hostzj:~# chmod -R 400 /home/www/kejishixun
root@hostzj:~# chmod -R 400 /home/www/hulianwangzixun
root@hostzj:~# chmod -R 400 /home/www/zuixinzixin
root@hostzj:~# chmod -R 400 /home/www/fangchanzixun
root@hostzj:~# chmod -R 400 /home/www/yulezonghe
root@hostzj:~# chmod -R 400 /home/www/jishizixun
UPDATE dede_arctiny SET typeid = REPLACE(`typeid`, '1031', '1032')
UPDATE dede_arctiny SET typeid = REPLACE(`typeid`, '1031', '1032')
{dede:arclist row='1000' pagesize='10' titlelen='35' orderby='rand'}
<li><a href="[field:arcurl/]">[field:title/]</a></li>
{/dede:arclist}
{dede:randomartlist row=1}{dede:arclist orderby='rand' row='200'}
<li><a href='[field:arcurl/]'>[field:title/]</a></li>
{/dede:arclist}{/dede:randomartlist}
{dede:likearticle row='' col='' titlelen='' infolen=''}
<a href='[field:arcurl/]'>[field:title/]</a>
{/dede:likearticle}
http://rate.tmall.com/list_detail_rate.htm?callback=jsonp1357727057926&itemId=20032252131&spuId=208454914&sellerId=848440571&order=0&forShop=1&append=0¤tPage=1
delayed_insert_timeout = 300
innodb_lock_wait_timeout = 60
innodb_rollback_on_timeout = OFF
interactive_timeout = 1128800
lock_wait_timeout = 31536000
net_read_timeout = 60
net_write_timeout = 60
wait_timeout = 1128800