2008年4月13日日曜日

DomU mdbm01の設定

# yum install mysql-server
# vi /etc/my.cnf
[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
big-tables
query_cache_type=1
query_cache_limit=1M
query_cache_min_res_unit=4k
query_cache_size=32M
table_cache=128
log-bin
server-id=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqld]
default-character-set=utf8
skip-character-set-client-handshake
ft_min_word_len=1

[mysql]
default-character-set=utf8

[mysqldump]
default-character-set = binary

[client]
default-character-set=utf8

#utf8を明示しないとエラー出るよ

0 件のコメント: