Mysql 字符集的困扰

        新装的 MySQL 5.0 无法恢复 4.0 的数据备份，接下来还得重新编译 php ，超郁闷呐！无奈，重装MySQL 4.0 是唯一道路 ！下载4.0.16 源文件...

shell> pw groupadd mysql shell> pw useradd mysql -g mysql

shell> tar zxvf mysql-4.0.16.tar.gz shell> cd mysql-4.0.16

shell> ./configure --prefix=/database/mysql --with-charset=gb2312 --with-extra-charsets=gbk,latin1,big5,cp1251

shell> make shell> make install shell> make install

shell> scripts/mysql_install_db

shell> chown -R root /usr/local/mysql

shell> chown -R mysql /usr/local/mysql/var

shell> chgrp -R mysql /usr/local/mysql

shell> cp support-files/my-medium.cnf /etc/my.cnf

shell> /usr/local/mysql/bin/mysqld_safe --user=mysql &