mysql取代字串語法

The easiest way I have found is to dump the database to a text file, run a sed command to do the replace, and reload the database back into MySQL.

All commands are bash on Linux, from memory.

Dump database to text file

mysqldump -u user -p databasename > ./db.sql

Run sed command to find/replace target string

sed -i 's/oldString/newString/g' ./db.sql

Reload the database into MySQL

mysql -u user -p databasename < ./db.sql

Easy peasy.

wget 直接下載google硬碟的檔案

首先將檔案設請網際網路上所有使用者均可以找到並檢視
接著用下列語法
wget --no-check-certificate https://googledrive.com/host/ID -O /本地端的檔案儲存路徑與檔名
其中的ID就是若你分享的連結為：https://drive.google.com/file/d/0B7wsIMxK5Td0dTNPdnNFtsdfwv/view?usp=sharing
即為0B7wsIMxK5Td0dTNPdnNFtsdfwv
換言之你的下載完整指令為wget --no-check-certificate https://googledrive.com/host/0B7wsIMxK5Td0dTNPdnNFtsdfwv -O /temp/test.tar.bz2

centos 降級php

yum downgrade php\*

在 CentOS 6.x 安裝 ClamAV

ClamAV 是 Linux 最常用來做防毒整合的套件之一，本文將介紹如何在 CentOS 6.x 中安裝 ClamAV。

新增 EPEL 套件來源

1	root # rpm -ivh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

安裝 ClamAV 套件

1	root # yum install clamav clamd clamav-devel -y

更新 ClamAV 病毒定議檔

1	root # freshclam

開機時啟用 ClamAV Daemon

1	root # service clamd start

測試掃掃檔案

1	root # clamscan -r /etc