Mysql UTF8 转为 GB2312

查看当前

show variables like 'character/_set/_%'

方法如下：
1:
执行：./mysqldump -uroot -p --default-character-set=utf8 --extended-insert=FALSE DBNAME > DBNAME_GB2312.sql

2:
sed -e '/^--/d' -e '/^///*/d' -e '/^$/d' -e 's/utf8_bin/gb2312_bin/' -e 's/utf8/latin1或者gb2312/' DBNAME_GB2312.sql > CONV_DBNAME_GB2312.sql

3:
执行：./mysql -uroot -p --default-character-set=utf8 DBNAME < CONV_DBNAME_GB2312.sql