binlog2sql icon indicating copy to clipboard operation
binlog2sql copied to clipboard

Mysql 8.0.32 导出时有报错 KeyError: 255

Open gaolc opened this issue 10 months ago • 2 comments

File "/root/app/binlog2sql/binlog2sql/binlog2sql.py", line 145, in binlog2sql = Binlog2sql(connection_settings=conn_setting, start_file=args.start_file, start_pos=args.start_pos, File "/root/app/binlog2sql/binlog2sql/binlog2sql.py", line 46, in init self.connection = pymysql.connect(**self.conn_setting) File "/usr/local/lib/python3.10/dist-packages/pymysql/init.py", line 90, in Connect return Connection(*args, **kwargs) File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 706, in init self.connect() File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 931, in connect self._get_server_information() File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 1269, in _get_server_information self.server_charset = charset_by_id(lang).name File "/usr/local/lib/python3.10/dist-packages/pymysql/charset.py", line 38, in by_id return self._by_id[id] KeyError: 255

gaolc avatar Mar 25 '25 06:03 gaolc

是否可以支持mysql8.0.32 , 应该PyMySQL==0.7.11 对这种字符类型不能支持, _charsets.add(Charset(255, "utf8mb4", "utf8mb4_0900_ai_ci"))

gaolc avatar Mar 25 '25 06:03 gaolc

需要更新PyMySQL到0.9.3,但对MySQL8解析出来的会出现字段错位

zgpnuaa avatar Jun 18 '25 14:06 zgpnuaa