数据库转换小Tip

转码并导入导出MySQL
  1. iconv -c -f utf-8 -t gbk example.sql > example_gb.sql
  2. /usr/local/mysql4.1/bin/mysql -pPASSWD -S /tmp/mysql4.1.sock --character-set=gbk -f database < example_gb.sql