MARIADB-BINLOG(1) MariaDB Database System MARIADB-BINLOG(1) (NAME) mariadb-binlog - (mariadb-binlog mariadb-binlog ) (SYNOPSIS) mariadb-binlog [options] log_file ... (DESCRIPTION) "" . . mariadb-binlog . mariadb-binlog relay log (slave) (replication) relay log . mariadb-binlog : shell> mariadb-binlog [options] log_file ... binlog.000003 : shell> mariadb-binlog binlog.0000003 binlog.000003 . (statement-based logging) SQL . (row-based logging) SQL . (header) . : # at 141 #100309 9:28:36 server id 123 end_log_pos 245 Query thread_id=3350 exec_time=11 error_code=0 at . . replication slave . server id server_id . end_log_pos ( + ). thread_id (thread) . exec_time (master) . (slave) slave master . replication master . error_code . . mariadb-binlog ( mariadb) . (crash) . . mariadb-binlog MariaDB . --read-from-remote-server . . --host --password --port --protocol --socket --user --read-from-remote-server . mariadb-binlog [mariadb-binlog] [client] . o --help, -? . o --base64-output=value BINLOG base-64 . ( ): o AUTO (<<>>) UNSPEC (<<>>) BINLOG ( ). --base64-output . BINLOG mariadb-binlog . ..sp .5v o NEVER BINLOG . BINLOG mariadb-binlog . o DECODE-ROWS mariadb-binlog --verbose SQL . NEVER DECODE-ROWS BINLOG NEVER . --base64-output --base64-output --skip-base64-output ( AUTO NEVER) . --base64-output --verbose "MARIADB-BINLOG ROW EVENT DISPLAY" . o --binlog-row-event-max-size=path . o --character-sets-dir=path . o --database=db_name, -d db_name mariadb- binlog ( ) db_name USE . --database mariadb-binlog --binlog-do-db mariadbd . --database . (statement-based) (row-based) --binlog-do-db . . --database : o db_name db_name . o db_name db_name . o CREATE DATABASE ALTER DATABASE DROP DATABASE . . (statement-based logging) : INSERT INTO test.t1 (i) VALUES(100); INSERT INTO db2.t2 (j) VALUES(200); USE test; INSERT INTO test.t1 (i) VALUES(101); INSERT INTO t1 (i) VALUES(102); INSERT INTO db2.t2 (j) VALUES(201); USE db2; INSERT INTO test.t1 (i) VALUES(103); INSERT INTO db2.t2 (j) VALUES(202); INSERT INTO t2 (j) VALUES(203); mariadb-binlog --database=test INSERT . INSERT USE test INSERT USE db2 . mariadb-binlog --database=db2 INSERT . INSERT USE test INSERT USE db2 . (Row-based logging). mariadb-binlog db_name . . (binary log) (statement-based logging) . mariadb-binlog --database=test USE t1 test . binlog_format MIXED mariadb-binlog --database USE . ( [cross-database updates] .) MySQL 5.1.37 mariadb-binlog . o --debug[=debug_options], -# [debug_options] . debug_options 'd:t:o,file_name' . 'd:t:o,/tmp/mariadb-binlog.trace' . o --debug-check . o --debug-info (CPU) . o --defaults-extra-file=name (global) . o --defaults-file=name . o --default-auth=name . o --disable-log-bin, -D.sp (binary logging). --to-last-log MariaDB . (crash) . SUPER . mariadb-binlog SET sql_log_bin = 0 . SET SUPER . o --flashback, -B (flashback mode). o --force-if-open binlog . --skip-force-if-open . o --force-read, -f mariadb- binlog . mariadb-binlog . o --hexdump, -H (hex dump) "MARIADB-BINLOG HEX DUMP FORMAT" . (replication) . o --host=host_name, -h host_name MariaDB (host) . o --local-load=path, -l path LOAD DATA INFILE . o --no-defaults (option file). o --offset=N, -o N N . o --open-files-limit=NUM open_files_limit (file descriptors) mariadb-binlog . o --password[=password], -p[password].sp . (-p) . password --password -p mariadb-binlog . . . o --plugin-dir=dir_name . o --print-defaults . o --port=port_num, -P port_num TCP/IP 0 : my.cnf $MYSQL_TCP_PORT /etc/services (3306). --protocol=tcp . o --protocol={TCP|SOCKET|PIPE|MEMORY} . . o --raw -R . binlog SQL. . o --read-from-remote-server, -R MariaDB . . --host --password --port --protocol --socket --user. . relay log. o --result-file=name, -r name . --raw . o --rewrite-db=name, -r name . : rewrite-db='from->to'. binlog db1 db2 . "db1.tbl" "db2.tbl" . (Row- based events) . ( --database=name) . ">" ( --rewrite-db="oldname->newname". o --server-id=id (server ID) . o --set-charset=charset_name SET NAMES charset_name . o --short-form -s (row-based events) . . base64 --base64-output=never . o --socket=path -S path localhost Windows (named pipe) . --protocol=socket Windows --protocol=pipe . o --start-datetime=datetime datetime . datetime mariadb-binlog . DATETIME TIMESTAMP . : shell> mariadb-binlog --start-datetime="2014-12-25 11:25:56" binlog.000003 (point-in-time recovery) . o --start-position=N -j N N . GTID . binlog N . GTID GTID (domain id) . gtid binlog ( <> ) . GTID . (point-in-time recovery) . o --gtid-strict-mode binlog gtid-strict-mode . (start) (stop) start < stop . gtid . o --stop-datetime=datetime datetime . (point-in-time recovery) . datetime --start-datetime . (point-in-time recovery) . o --stop-never . --to-last-log . o --stop-never-slave-server-id server_id slave --read-from-remote- server --stop-never . o --stop-position=N N . GTID . . GTID GTID domain id . GTID (inclusive) . (point-in-time recovery) . o --table, -T ( ). o --to-last-log, -t MariaDB . MariaDB --read-from-remote-server . o --user=user_name, -u user_name MariaDB . o --verbose, -v (row events) SQL . (metadata) . . --base64-output --verbose "MARIADB-BINLOG ROW EVENT DISPLAY" . o --version, -V . --var_name=value : o open_files_limit (file descriptors) . mariadb-binlog mariadb (pipe) . (crash) . : shell> mariadb-binlog binlog.000001 | mariadb -u root -p : shell> mariadb-binlog binlog.[0-9]* | mariadb -u root -p ( ) mariadb-binlog . mariadb : shell> mariadb-binlog binlog.000001 > tmpfile shell> ... edit tmpfile ... shell> mariadb -u root -p < tmpfile mariadb-binlog --start-position ( ). . --stop-datetime (point-in-time recovery) ( : " : ")..PP (binary log) MariaDB . : shell> mariadb-binlog binlog.000001 | mariadb -u root -p # DANGER!! shell> mariadb-binlog binlog.000002 | mariadb -u root -p # DANGER!! CREATE TEMPORARY TABLE . mariadb . mariadb "unknown table." . mariadb . : shell> mariadb-binlog binlog.000001 binlog.000002 | mariadb -u root -p : shell> mariadb-binlog binlog.000001 > /tmp/statements.sql shell> mariadb-binlog binlog.000002 >> /tmp/statements.sql shell> mariadb -u root -p -e "source /tmp/statements.sql" mariadb-binlog LOAD DATA INFILE . mariadb-binlog LOAD DATA LOCAL INFILE . . --local-load . mariadb-binlog LOAD DATA INFILE LOAD DATA LOCAL INFILE ( LOCAL ) LOCAL . LOAD DATA LOCAL . . original_file_name-#-# . --hexdump mariadb-binlog : shell> mariadb-binlog --hexdump master-bin.000001 # : /*!40019 SET @@session.max_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; # at 4 #051024 17:24:13 server id 1 end_log_pos 98 # Position Timestamp Type Master ID Size Master Pos Flags # 00000004 9d fc 5c 43 0f 01 00 00 00 5e 00 00 00 62 00 00 00 00 00 # 00000017 04 00 35 2e 30 2e 31 35 2d 64 65 62 75 67 2d 6c |..5.0.15.debug.l| # 00000027 6f 67 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |og..............| # 00000037 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................| # 00000047 00 00 00 00 9d fc 5c 43 13 38 0d 00 08 00 12 00 |.......C.8......| # 00000057 04 04 04 04 12 00 00 4b 00 04 1a |.......K...| # Start: binlog v 4, server v 5.0.15-debug-log created 051024 17:24:13 # at startup ROLLBACK; . . ( : http://forge.mysql.com/wiki/MySQL_Internals_Binary_Log.) o Position: . o Timestamp: . '9d fc 5c 43' '051024 17:24:13' () . o Type: . '0f' FORMAT_DESCRIPTION_EVENT . . +----------+-----------------------------+-----------------+ | | | | +----------+-----------------------------+-----------------+ |00 | UNKNOWN_EVENT | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |01 | START_EVENT_V3 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MySQL 4 | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |02 | QUERY_EVENT | | | | | | | | | . | | | | | | | | | | | | | | | | | | | | | | | | master | | | | . | +----------+-----------------------------+-----------------+ |03 | STOP_EVENT | | | | | | | | | | | | | | | | | master | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |04 | ROTATE_EVENT | | | | | | | | | | | | | | | | | | | | | master | | | | | | | | | | | | | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |05 | INTVAR_EVENT | | | | | | | | | AUTO_INCREMENT | | | | | | | | | | | | | | | | | | | | LAST_INSERT_ID() | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |06 | LOAD_EVENT | | | | | LOAD DATA | | | | INFILE | | | | MySQL 3.23 | | | | | | | | . | +----------+-----------------------------+-----------------+ |07 | SLAVE_EVENT | | | | | | | | | | | | | | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |08 | CREATE_FILE_EVENT | | | | | | | | | LOAD DATA | | | | INFILE | | | | | | | | . | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | | | | | | | | | | | | | | | | slave | | | | | | | | . | | | | | | | | MySQL 4 | | | | | | | | . | +----------+-----------------------------+-----------------+ |09 | APPEND_BLOCK_EVENT | | | | | | | | | | | | | | | | | | | | | | | | | LOAD DATA | | | | INFILE | | | | . | | | | | | | | | | | | | | | | | | | | | | | | slave | | | | | | | | . | +----------+-----------------------------+-----------------+ |0a | EXEC_LOAD_EVENT | | | | | | | | | LOAD DATA | | | | INFILE | | | | | | | | . | | | | | | | | | | | | | | | | | | | | | | | | slave | | | | | | | | . | | | | | | | | MySQL 4 | | | | | | | | . | +----------+-----------------------------+-----------------+ |0b | DELETE_FILE_EVENT | | | | | (Rollback) | | | | | | | | | | | | LOAD DATA | | | | INFILE. | | | | | | | | | | | | | | | | slave | | | | | | | | . | +----------+-----------------------------+-----------------+ |0c | NEW_LOAD_EVENT | | | | | LOAD DATA | | | | INFILE | | | | MySQL 4 | | | | | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |0d | RAND_EVENT | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | RAND() | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |0e | USER_VAR_EVENT | | | | | | | | | | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |0f | FORMAT_DESCRIPTION_EVENT | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MySQL 5 | | | | | | | | . | +----------+-----------------------------+-----------------+ |10 | XID_EVENT | | | | | | | | | | | | | | | | | | | | | (commit) | | | | | | | | XA . | +----------+-----------------------------+-----------------+ |11 | BEGIN_LOAD_QUERY_EVENT | | | | | | | | | LOAD DATA | | | | INFILE | | | | MySQL 5 | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |12 | EXECUTE_LOAD_QUERY_EVENT | | | | | | | | | LOAD DATA | | | | INFILE | | | | MySQL 5 | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |13 | TABLE_MAP_EVENT | | | | | | | | | | | | | | | | | . | | | | MySQL | | | | 5.1.5 | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |14 | PRE_GA_WRITE_ROWS_EVENT | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | | | | MySQL | | | | 5.1.5 | | | | 5.1.17 | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |15 | PRE_GA_UPDATE_ROWS_EVENT | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | | | | MySQL | | | | 5.1.5 | | | | 5.1.17 | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |16 | PRE_GA_DELETE_ROWS_EVENT | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | | | | MySQL | | | | 5.1.5 | | | | 5.1.17 | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |17 | WRITE_ROWS_EVENT | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | | | | MySQL | | | | 5.1.18 | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |18 | UPDATE_ROWS_EVENT | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | | | | MySQL | | | | 5.1.18 | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |19 | DELETE_ROWS_EVENT | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | | | | MySQL | | | | 5.1.18 | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |1a | INCIDENT_EVENT | | | | | | | | | | | | | | | | | . | | | | MySQL | | | | 5.1.18 | | | | | | | | . .TEo | | | | Master ID: | | | | | | | | | | | | (server ID) | | | | | | | | master | | | | | | | | | | | | | | | | | | | | .o | | | | Size: | | | | | | | | | | | | | | | | | | | | .o | | | | Master Pos: | | | | | | | | | | | | | | | | | | | | | | | | | | | | (log file) | | | | | | | | | | | | master.o | | | | Flags: | | | | . | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | | | | allbox tab(:); | | | | l l lx. T{ | | | | | +----------+-----------------------------+-----------------+ | | | | +----------+-----------------------------+-----------------+ |T} | | | +----------+-----------------------------+-----------------+ |01 | LOG_EVENT_BINLOG_IN_USE_F | | | | | | | | | | | | | | | | | | | | | . | | | | ( | | | | | | | | FORMAT_DESCRIPTION_EVENT | | | | | | | | .) | | | | | | | | | | | | | | | | | | | | | | | | | | | | ( | | | | | | | | | | | | | | | | '01 00' | | | | ) | | | | | | | | FORMAT_DESCRIPTION_EVENT | | | | | | | | | | | | | | | | | | | | | | | | . | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | master | | | | ( | | | | | | | | | | | | | | | | | | | | ) | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |02 | | | | | | | | | | | | | | | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ |04 | LOG_EVENT_THREAD_SPECIFIC_F | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ( | | | | | | | | '04 00') | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | (temporary | | | | tables) | | | | | | | | . | +----------+-----------------------------+-----------------+ |08 | LOG_EVENT_SUPPRESS_USE_F | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | . | +----------+-----------------------------+-----------------+ mariadb-binlog (row events) . WRITE_ROWS_EVENT UPDATE_ROWS_EVENT DELETE_ROWS_EVENT . --base64-output=DECODE-ROWS --verbose . (row-based binary logging) : CREATE TABLE t ( id INT NOT NULL, name VARCHAR(20) NOT NULL, date DATE NULL ) ENGINE = InnoDB; START TRANSACTION; INSERT INTO t VALUES(1, 'apple', NULL); UPDATE t SET name = 'pear', date = '2009-01-01' WHERE id = 1; DELETE FROM t WHERE id = 1; COMMIT; mariadb-binlog BINLOG base-64 . : shell> mariadb-binlog log_file ... # at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG 'fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ=='/*!*/; ... # at 302 #080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F BINLOG 'fAS3SBMBAAAALAAAAC4BAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBgBAAAANgAAAGQBAAAQABEAAAAAAAEAA////AEAAAAFYXBwbGX4AQAAAARwZWFyIbIP'/*!*/; ... # at 400 #080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F BINLOG 'fAS3SBMBAAAALAAAAJABAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBkBAAAAKgAAALoBAAAQABEAAAAAAAEAA//4AQAAAARwZWFyIbIP'/*!*/; " (pseudo-SQL)" mariadb-binlog --verbose -v . ### : shell> mariadb-binlog -v log_file ... # at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG 'fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ=='/*!*/; ### INSERT INTO test.t ### SET ### @1=1 ### @2='apple' ### @3=NULL ... # at 302 #080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F BINLOG 'fAS3SBMBAAAALAAAAC4BAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBgBAAAANgAAAGQBAAAQABEAAAAAAAEAA////AEAAAAFYXBwbGX4AQAAAARwZWFyIbIP'/*!*/; ### UPDATE test.t ### WHERE ### @1=1 ### @2='apple' ### @3=NULL ### SET ### @1=1 ### @2='pear' ### @3='2009:01:01' ... # at 400 #080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F BINLOG 'fAS3SBMBAAAALAAAAJABAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBkBAAAAKgAAALoBAAAQABEAAAAAAAEAA//4AQAAAARwZWFyIbIP'/*!*/; ### DELETE FROM test.t ### WHERE ### @1=1 ### @2='pear' ### @3='2009:01:01' --verbose -v . : shell> mariadb-binlog -vv log_file ... # at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG 'fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ=='/*!*/; ### INSERT INTO test.t ### SET ### @1=1 /* INT meta=0 nullable=0 is_null=0 */ ### @2='apple' /* VARSTRING(20) meta=20 nullable=0 is_null=0 */ ### @3=NULL /* VARSTRING(20) meta=0 nullable=1 is_null=1 */ ... # at 302 #080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F BINLOG 'fAS3SBMBAAAALAAAAC4BAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBgBAAAANgAAAGQBAAAQABEAAAAAAAEAA////AEAAAAFYXBwbGX4AQAAAARwZWFyIbIP'/*!*/; ### UPDATE test.t ### WHERE ### @1=1 /* INT meta=0 nullable=0 is_null=0 */ ### @2='apple' /* VARSTRING(20) meta=20 nullable=0 is_null=0 */ ### @3=NULL /* VARSTRING(20) meta=0 nullable=1 is_null=1 */ ### SET ### @1=1 /* INT meta=0 nullable=0 is_null=0 */ ### @2='pear' /* VARSTRING(20) meta=20 nullable=0 is_null=0 */ ### @3='2009:01:01' /* DATE meta=0 nullable=1 is_null=0 */ ... # at 400 #080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F BINLOG 'fAS3SBMBAAAALAAAAJABAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBkBAAAAKgAAALoBAAAQABEAAAAAAAEAA//4AQAAAARwZWFyIbIP'/*!*/; ### DELETE FROM test.t ### WHERE ### @1=1 /* INT meta=0 nullable=0 is_null=0 */ ### @2='pear' /* VARSTRING(20) meta=20 nullable=0 is_null=0 */ ### @3='2009:01:01' /* DATE meta=0 nullable=1 is_null=0 */ --base64-output=DECODE-ROWS mariadb-binlog BINLOG . --base64-output=NEVER . --base64-output=DECODE-ROWS --verbose SQL :.sp shell> mariadb-binlog -v --base64-output=DECODE-ROWS log_file ... # at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F ### INSERT INTO test.t ### SET ### @1=1 ### @2='apple' ### @3=NULL ... # at 302 #080828 15:03:08 server id 1 end_log_pos 356 Update_rows: table id 17 flags: STMT_END_F ### UPDATE test.t ### WHERE ### @1=1 ### @2='apple' ### @3=NULL ### SET ### @1=1 ### @2='pear' ### @3='2009:01:01' ... # at 400 #080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F ### DELETE FROM test.t ### WHERE ### @1=1 ### @2='pear' ### @3='2009:01:01' mariadb-binlog BINLOG . SQL --verbose BINLOG . SQL . : o @N N . o : o (BINARY CHAR VARBINARY VARCHAR BLOB TEXT). STRING VARSTRING . o . STRING(4) : CHAR(4) CHARACTER SET latin1 CHAR(2) CHARACTER SET ucs2 o UPDATE_ROWS_EVENT UPDATE WHERE SET . (format description event) . mariadb-binlog BINLOG . BINLOG ( ) --base64-output=NEVER ..SH " (COPYRIGHT)" 2007-2008 MySQL AB 2008-2010 Sun Microsystems, Inc. 2010-2025 MariaDB Foundation (GNU General Public License) (Free Software Foundation) / . . (GNU General Public License) . GNU General Public License Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA http://www.gnu.org/licenses . (NOTES) 1. Bug#42941 http://bugs.mysql.com/bug.php?id=42941 (SEE ALSO) MariaDB https://mariadb.com/docs . (AUTHORS) MariaDB Foundation (http://www.mariadb.org). MariaDB 11.8 5 March 2025 MARIADB-BINLOG(1)