DEFAULT CHARSET 出错无法导入

今天MYSQL 数据库导进去出错。。报错如下。。



Query OK, 0 rows affected (0.00 sec)

ERROR 1115 (42000): Unknown character set: 'gb2312'
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'adminguaipengcn.ftpd' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1115 (42000): Unknown character set: 'gb2312'
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1115 (42000): Unknown character set: 'gb2312'
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'adminguaipengcn.ftpd_copy' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1115 (42000): Unknown character set: 'gb2312'
Query OK, 0 rows affected (0.00 sec)



后来仔细一看。。 两台服务器的数据库有如下不同。。
ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;
ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=gb2312;
然后改一下就OK