今天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
阅读(882) | 评论(1) | 转发(0) |