mysqlbinlog: unknown variable ‘default-character-set=utf8’

14.11.2019 - Записи в блоге

Проблема:

root@db1:~# mysqlbinlog /var/lib/mysql/mysql-bin.000065 | tail -n 9
mysqlbinlog: unknown variable 'default-character-set=utf8mb4'
root@db1:~#

Решение:

root@db1:~# mysqlbinlog --no-defaults /var/lib/mysql/mysql-bin.000065 | tail -n 9
mysqlbinlog: O_TMPFILE is not supported on /tmp (disabling future attempts)
ERROR: Error in Log_event::read_log_event(): 'Event truncated', data_len: 1044004, event_type: 2
#191110 13:18:33 server id 1  end_log_pos 316384751 CRC32 0xb3498009    GTID 0-1-72255
/*!100001 SET @@session.gtid_seq_no=72255*//*!*/;
BEGIN
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
root@db1:~#

 

› tags: mysql / mysqlbinlog / unknown variable 'default-character-set=utf8' /