GODADDY的MYSQL用phpmyadmin导出中文为乱码

skykycn

GODADDY的MYSQL应该怎么备份啊....

用phpmyadmin 导出.sql的文件中文的全是乱码,请问一下要选择什么编码导出才不会出现乱码啊,

我的是unix 操作系统

请说具体一点,

服务器版本: 5.0.91-log
服务器: w2jianf.db.5471916.hostedresource.com (72.167.233.30 via TCP/IP)
用户: w2jianf@72.167.233.37
MySQL 字符集: UTF-8 Unicode (utf8)

主要是这个选择什么编码 MySQL 连接校对:  我试了很多都不行哦.

MySQL 连接校对:  整理
armscii8_bin armscii8_general_ci   ascii_bin ascii_general_ci   big5_bin big5_chinese_ci   binary   cp1250_bin cp1250_croatian_ci cp1250_czech_cs cp1250_general_ci   cp1251_bin cp1251_bulgarian_ci cp1251_general_ci cp1251_general_cs cp1251_ukrainian_ci   cp1256_bin cp1256_general_ci   cp1257_bin cp1257_general_ci cp1257_lithuanian_ci   cp850_bin cp850_general_ci   cp852_bin cp852_general_ci   cp866_bin cp866_general_ci   cp932_bin cp932_japanese_ci   dec8_bin dec8_swedish_ci   eucjpms_bin eucjpms_japanese_ci   euckr_bin euckr_korean_ci   gb2312_bin gb2312_chinese_ci   gbk_bin gbk_chinese_ci   geostd8_bin geostd8_general_ci   greek_bin greek_general_ci   hebrew_bin hebrew_general_ci   hp8_bin hp8_english_ci   keybcs2_bin keybcs2_general_ci   koi8r_bin koi8r_general_ci   koi8u_bin koi8u_general_ci   latin1_bin latin1_danish_ci latin1_general_ci latin1_general_cs latin1_german1_ci latin1_german2_ci latin1_spanish_ci latin1_swedish_ci   latin2_bin latin2_croatian_ci latin2_czech_cs latin2_general_ci latin2_hungarian_ci   latin5_bin latin5_turkish_ci   latin7_bin latin7_estonian_cs latin7_general_ci latin7_general_cs   macce_bin macce_general_ci   macroman_bin macroman_general_ci   sjis_bin sjis_japanese_ci   swe7_bin swe7_swedish_ci   tis620_bin tis620_thai_ci   ucs2_bin ucs2_czech_ci ucs2_danish_ci ucs2_esperanto_ci ucs2_estonian_ci ucs2_general_ci ucs2_hungarian_ci ucs2_icelandic_ci ucs2_latvian_ci ucs2_lithuanian_ci ucs2_persian_ci ucs2_polish_ci ucs2_roman_ci ucs2_romanian_ci ucs2_slovak_ci ucs2_slovenian_ci ucs2_spanish2_ci ucs2_spanish_ci ucs2_swedish_ci ucs2_turkish_ci ucs2_unicode_ci   ujis_bin ujis_japanese_ci   utf8_bin utf8_czech_ci utf8_danish_ci utf8_esperanto_ci utf8_estonian_ci utf8_general_ci utf8_hungarian_ci utf8_icelandic_ci utf8_latvian_ci utf8_lithuanian_ci utf8_persian_ci utf8_polish_ci utf8_roman_ci utf8_romanian_ci utf8_slovak_ci utf8_slovenian_ci utf8_spanish2_ci utf8_spanish_ci utf8_swedish_ci utf8_turkish_ci utf8_unicode_ci   

显示 MySQL 的系统变量
进程
字符集和整理
数据库
导出
Import
登出

skykycn

我还有了godaddy 自带的备份, 备份出来的.sql,中文的也是乱码,要如何解决. 我现在要把数据库转到国内空间上了. 哎,  就是数据库转不起啊.   


请求版主帮助哦. :Q