--base64-output

This page is part of MariaDB's Documentation.

The parent of this page is: mariadb-binlog & mysqlbinlog

Topics on this page:

• Overview

• USAGE

• DETAILS

  • SYNONYMS

  • SCHEMA

  • PARAMETERS

  • SKYSQL

  • PRIVILEGES

• EXAMPLES

• ERROR HANDLING

• FEATURE INTERACTION

• RESPONSES

• DIAGNOSIS

• ISO 9075:2016

• CHANGE HISTORY

• RELATED TOPICS

• EXTERNAL REFERENCES

Overview

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

In 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 10.6, 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