2012/06/29

cue sheet still mojibake in UTF-8

foobar read cue in UTF-8 only when a BOM is seen, so it is necessary to insert a BOM.

to do so in vim, set bomb before save the file

2012/06/03

Build MySQL

First get the source from mysql website (login required)
    http://dev.mysql.com/downloads/mirror.php?id=408409

Extract the source
    tar xzf mysql-5.5.25.tar.gz

Build with option
    cmake . -DCMAKE_INSTALL_PREFIX=$topt/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_SSL=yes -DMYSQL_UNIX_ADDR=$topt/tmp/mysql.sock
    make && make install

    There is problem when specifying self built openssl libraries so just let mysql detect it

run mysqld with option
    mysqld_safe --defaults-file=$defaults &

    reference: http://dev.mysql.com/doc/refman/5.6/en/server-options.html
                     http://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html