--base64-output

Overview

This is a command-line option for the mariadb-binlog & mysqlbinlog commands (arg: Required).

In 23.08 ES, 23.07 ES, 10.6 ES, 10.6 CS:

Determine when the output statements should be base64-encoded BINLOG statements: 'never' neither prints base64 encodings nor verbose event data, and will exit on error if a row-based event is found. 'decode-rows' decodes row events into commented SQL statements if the --verbose option is also given. 'auto' outputs base64 encoded entries for row-based and format description events. If no option is given at all, the default is 'auto', and is consequently the only option that should be used when row-format events are processed for re-execution.

In 10.5 ES, 10.5 CS:

Determine when the output statements should be base64-encoded BINLOG statements: 'never' doesn't print binlog row events and should not be used when directing output to a MariaDB master; 'decode-rows' decodes row events into commented SQL statements if the --verbose option is also given; 'auto' prints base64 only when necessary (i.e., for row-based events and format description events); If no --base64-output=name option is given at all, the default is 'auto'.

In 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS:

Determine when the output statements should be base64-encoded BINLOG statements: 'never' doesn't print binlog row events and should not be used when directing output to a MariaDB master; 'decode-rows' decodes row events into commented SQL statements if the --verbose option is also given; 'auto' prints base64 only when necessary (i.e., for row-based events and format description events); 'always' prints base64 whenever possible. --base64-output with no 'name' argument is equivalent to --base64-output=always and is also deprecated. If no --base64-output[=name] option is given at all, the default is 'auto'.

In 10.2 ES, 10.2 CS:

Determine when the output statements should be base64-encoded BINLOG statements: 'never' disables it and works only for binlogs without row-based events; 'decode-rows' decodes row events into commented SQL statements if the --verbose option is also given; 'auto' prints base64 only when necessary (i.e., for row-based events and format description events); 'always' prints base64 whenever possible. 'always' is deprecated, will be removed in a future version, and should not be used in a production system. --base64-output with no 'name' argument is equivalent to --base64-output=always and is also deprecated. If no --base64-output[=name] option is given at all, the default is 'auto'.

See also: Options for mariadb-binlog & mysqlbinlog in MariaDB Enterprise Server 23.08, in 23.07 ES, in 10.6 ES, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

  • Removed in MariaDB Community Server 10.3.36.

  • Added in MariaDB Community Server 10.3.38.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

EXTERNAL REFERENCES