更改MySQL database的路徑

建議用 mysql 4.1 (下面這些沒測過)

cd /usr/ports/databases/mysql41-server/
make WITH_CHARSET=utf8 BUILD_OPTIMIZED=yes BUILD_STATIC=yes install

如果要將 database 的檔案放在 /home/mysql 的話用

mv /var/db/mysql /home/mysql
ln -s /home/mysql /var/db/mysql

並在 /etc/rc.conf 中加入

mysql_enable="YES"

php mysql utf-8 connection

因網頁都已改用utf-8傳送資料，
故所有table一開始都使用utf-8。

在database連線建立後，使用以下指令即可。

if (!mysqli_query($conn, "SET NAMES 'UTF8'"))
return false;
if (!mysqli_query($conn, "SET CHARACTER SET UTF8"))
return false;

Restore the Show Desktop shortcut on Quick Launch Bar

TIP: Restore the Show Desktop shortcut on Quick Launch Bar

Copy and paste the following lines into a Notepad file.

[Shell]
Command=2
IconFile=explorer.exe,3
[Taskbar]
Command=ToggleDesktop

Save the file to your Desktop as Show Desktop.scf. Next left click
on the file you just created and drag it down to the Quick Launch bar
and release.

Change Windows XP CD key

如因特殊情況需更改 Windows XP 的序列號可按下程序執行
1. 在〔開始〕→〔執行〕→〔Regedit〕→〔HKEY_LOCAL_MACHINE〕→〔SOFTWARE〕
→〔Microsoft〕→〔Windows NT〕→〔CurrentVersion〕
在〔WPAEvents〕內將〔OOBETimer〕的頭兩個數值〔CA〕刪除
2. 在〔開始〕→〔執行〕→〔oobe/msoobe /a〕進入〔啟動畫面〕→選擇第二項〔電話啟動〕
在進入下一個視窗，選擇〔change product key〕來修改序列號及輸入新的序列號，
完成後點擊〔update〕進行更新及選〔remind me later〕
3. 重新啟動電腦後 在〔開始〕→〔執行〕→〔oobe/msoobe /a〕
進入〔啟動畫面〕時應該顯示已經啟動

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q328874

1. Click Start, and then click Run.
2. In the Open box, type regedit, and then click OK.
3. In the left pane, locate and then click the following registry key:
HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\Current
Version\WPAEvents
4. In the right pane, right-click OOBETimer, and then click Modify.
5. Change at least one digit of this value to deactivate Windows.
6. Click Start, and then click Run.
7. In the Open box, type the following command, and then click OK.
%systemroot%\system32\oobe\msoobe.exe /a
8. Click Yes, I want to telephone a customer service representative to
activate Windows, and then click Next.
9. Click Change Product key.
10. Type the new product key in the New key boxes, and then click
Update.

If you are returned to the previous window, click Remind me later, and
then restart the computer.
11. Repeat steps 6 and 7 to verify that Windows is activated. You
receive the following message:
Windows is already activated. Click OK to exit.
12. Click OK.

freebsd 7.0 Release install procedure

fetch
setenv HTTP_PROXY
ntpd.conf
ftp/pure-ftpd
port-mgmt/portsnap
database/mysql
www/apahce22
edit /etc/newsyslog.conf
/var/log/httpd-access.log 644 3 1 @T00 Z
/var/log/httpd-error.log 644 3 1 @T00 Z /var/run/httpd.pid

lang/php5(check apache module)
edit httpd.conf
cacti