mysql 相关
http://linux.chinaunix.net/techdoc/database/2008/03/23/986386.sht把 /usr/local/mysql/support-files 下的 *.cnf复制一个到 /etc/下 名字为 my.cnf ，建议用my-small.cnf。
<div class="detail">修改MySQL缺省字符集为utf8，改my.cnf文件
default_character_set=utf8
# default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci
default_character_set=utf8
通过上面的设置后，重启mysql(命令：$ /opt/lampp/lampp reloadmysql),再登录msyql,show variables like "%char%"看看，是否正确。(命令：msyql> show variables like "%char%")
查看结果类似如下：
+--------------------------+---------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | D:"mysql-5.0.37"share"charsets" |
+--------------------------+---------------------------------+
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
另外：修改MySQL缺省字符集为GBK，改my.cnf文件
代码
# default-character-set=gbk
character-set-server = gbk
collation-server = gbk_chinese_ci
default_character_set=gbk
default_character_set=gbk
查看表字符集
show create table mytable
查看数据库的字符集
show create database mydatabase
更改数据库的字符集
alter database miniweb character set utf8;
更改表的字符集
alter table acct_authority character set utf8
关闭mysql服务
mysqladmin shutdown
启动
msqld_safe
数据备份
mysqldump -uroot -p --default-character-set=utf8 --opt --extended-insert=false --triggers -R --hex-blob -x miniweb > miniweb.sql
数据恢复
mysql -uroot -p zhou < miniweb.sql
页:
[1]