James's BLOG

MySQL database Latin1 to UTF-8

以 latin1 匯出資料庫
mysqldump -u root -p --default-character-set=latin1 database > database.sql
進入 MySQL 以 utf8_general_ci 字元建立資料庫
CREATE DATABASE database_utf8
取代匯出資料的內容 SET NAMES latin1 --> SET NAMES utf8
sed -e 's/SET NAMES latin1/SET NAMES utf8/g' database.sql > database_1.sql
取代匯出資料的內容 CHARSET=latin1 --> HARSET=utf8 COLLATE=utf8_general_ci
sed -e 's/CHARSET=latin1/CHARSET=utf8 COLLATE=utf8_general_ci/g' database_1.sql > database_2.sql
取代匯出資料的內容 CHARSET=latin1 --> HARSET=utf8 COLLATE=utf8_general_ci
sed -e 's/CHARACTER SET latin1 COLLATE latin1_bin/CHARACTER SET utf8 COLLATE utf8_general_ci/g' database_2.sql > database_3.sql
匯入資料庫
mysql -u root -p database_utf8 < database_3.sql

匯入資料時遇到錯誤, 像重覆Key值時, 假如不重要的table, 就把INSERT都刪掉.

ERROR 1062 (23000) at line 1891: Duplicate entry '?' for key 1

CSS text overflow 處理文字溢位

text-overflow

參考
http://www.w3schools.com/cssref/css3_pr_text-overflow.asp

MySQL error “Row XXX was cut by GROUP_CONCAT()”

使用 MySQL GROUP_CONCAT時, 會出現錯誤訊息如標題.

這時就要設定MySQL的

SET group_concat_max_len=15000;

15000隨個人需求設定.

參考
http://stackoverflow.com/questions/7208773/mysql-row-30153-was-cut-by-group-concat-error

FreeBSD SFTP 設定

參考這篇

http://bin63.com/how-to-set-up-an-sftp-user-on-freebsd

phpMyAdmin 隱藏資料庫 information_schema

單一隱藏

$cfg['Servers'][$i]['hide_db'] = 'information_schema';

多個隱藏則使用正規表達式

$cfg['Servers'][$i]['hide_db'] = '(information_schema|phpmyadmin|mysql)';

參考這篇

http://wiki.phpmyadmin.net/pma/Talk:Config

Apache & MySQL Connection Setting

Apache

檢查Apache 版本及運行腳本
httpd -v, httpd -l
設定Apache22/extra/httpd-mpm.conf

找到腳本設定


    StartServers          5
    MinSpareServers       5
    MaxSpareServers       10
    MaxClients            1000 (150改1000)
    MaxRequestsPerChild   2000 (0改2000)