Character Encoding and Database Transcoding Project
编码简介与主库转码总结 from Ho Kim Cheers~ Continue reading
Posted in 56com, Architecture, MySQL, PHP, Training
Tagged Character Set, Encoding, GBK, ISO-8859-1, Latin1, Mysql, Transcoding, Unicode, UTF-8, 编码, 转码
1 Comment
Master-Slave MySQL-5.1 Replication
Environment: RHEL: 5.3 MySQL: 5.1.54 Master : 1. MySQL user and group [codesyntax lang="bash"] $ groupadd mysql $ useradd -g mysql mysql [/codesyntax] 2. Download and install MySQL [codesyntax lang="b… Continue reading
Compile Mysql Extension for PHP
1. PHP Source : /home/kim/php-5.3.3 Path : /usr/local/php 2. Compile Mysql Extension [codesyntax lang="bash" lines="no" container="pre" tab_width="4"] $ cd /home/kim/php-5.3.3/ext/mysql/ $ /usr/local/… Continue reading
Shell – MySQL Query
[codesyntax lang="bash" lines="no" container="pre" tab_width="4"] #!/bin/bash # configs host='localhost'; user='kim'; pass='xxxxxx'; database='test_database'; # select from database query=`mysql -h$ho… Continue reading