修改 windows: mysql-root/my.ini  (mysql-4.1.14-win32.zip)
     linux:   /etc/my.cnf
將其中的default-character-set都改成gbk
也就是如下兩個SECTION
[client] 
。。。。
default-character-set=gbk
。。。。

[mysqld]
。。。。
default-character-set=gbk
。。。。

Linux上：
mysql> show variables like "%set%";
+--------------------------+----------------------------------------------------
----------------------+
| Variable_name            | Value
                      |
+--------------------------+----------------------------------------------------
----------------------+
| character_set_client     | gbk
                      |
| character_set_connection | gbk
                      |
| character_set_database   | gbk
                      |
| character_set_results    | gbk
                      |
| character_set_server     | gbk
                      |
| character_set_system     | utf8
                      |
| character_sets_dir       | /usr/local/mysql-standard-4.1.12-pc-linux-gnu-i686/
share/mysql/charsets/ |
+--------------------------+----------------------------------------------------
----------------------+
7 rows in set (0.00 sec)
此時可以查看中文的字段，應(yīng)該一切正常顯示。如果不正常顯示說明數(shù)據(jù)庫中存放的不是正確編碼。

Windows上：
mysql> show variables like "%set%";
+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_client     | latin1                   |
| character_set_connection | latin1                   |
| character_set_database   | gbk                      |
| character_set_results    | latin1                   |
| character_set_server     | gbk                      |
| character_set_system     | utf8                     |
| character_sets_dir       | D:\MySql\share\charsets/ |
+--------------------------+--------------------------+
7 rows in set (0.00 sec)

不知道為什么在windows上my.ini中
[client]
。。。。
default-character-set=gbk
沒有起作用。

Windows上登錄mysql，更改會話的編碼為gbk

mysql> set names "gbk";
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like "%set%";
+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_client     | gbk                      |
| character_set_connection | gbk                      |
| character_set_database   | gbk                      |
| character_set_results    | gbk                      |
| character_set_server     | gbk                      |
| character_set_system     | utf8                     |
| character_sets_dir       | D:\MySql\share\charsets/ |
+--------------------------+--------------------------+
7 rows in set (0.00 sec)

此時可以查看中文的字段，應(yīng)該一切正常顯示。如果不正常顯示說明數(shù)據(jù)庫中存放的不是正確編碼。

完全備份MySql
Linux上：
  mysqldump  --user=myname --password=mypassword  mydb >mydb_backup.sql
Windows上：
 Linux上：
  mysqldump   --default-character-set=gb2312 --user=myname --password=mypassword  mydb >mydb_backup.sql

Windows腳本自動登陸
D:\MySql\bin>mysql  --user=myname  --password=mypassword   --default-character-set=gbk   --host=192.168.0.17