Skip to content

Support MariaDB mariadb-binlog which translates a MariaDB binlog to SQL queries #9887

@timsehn

Description

@timsehn

Currently, a user encountered the following errors:

mariadb-binlog mariadb-bin.000001 mariadb-bin.000002 mariadb-bin.000003 mariadb-bin.000004 | mariadb -u root -p -h 127.0.0.1 --skip-ssl
Enter password:
--------------
BINLOG '
0i3WaA8qAAAA/AAAAAABAAAAAAQAMTEuOC4zLU1hcmlhREItdWJ1MjQwNC1sb2cAAAAAAAAAAAAA
...
'
--------------
ERROR 1105 (HY000) at line 8: syntax error at position 7 near 'BINLOG'

and:

mariadb-binlog --base64-output=DECODE-ROWS --verbose mariadb-bin.000001 mariadb-bin.000002 mariadb-bin.000003 mariadb-bin.000004 | mariadb -u root -p -h 127.0.0.1 --skip-ssl
Enter password:
--------------
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0, @@session.explicit_defaults_for_timestamp=1, @@session.system_versioning_insert_history=0
--------------
ERROR 1105 (HY000) at line 22: Unknown system variable 'check_constraint_checks'

There may be others so we should make a MariaDB binlog and test it.

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions