mysqlbinlog — Utility for Processing Binary Log Files accounts that do not authenticate with one of those plugins. It is also ignored if RSA-based password exchange is not used, as is the case when the client connects to the server using a secure connection. If  --server-public-key-path= file_name  is given and specifies a valid public key file, it takes precedence over  --get-server-public-key . For  sha256_password , this option applies only if MySQL was built using OpenSSL. For information about the  sha256_password  and  caching_sha2_password  plugins, see Section 6.4.1.3, “SHA-256 Pluggable Authentication” , and Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication” . Add a  SET NAMES  charset_name  statement to the output to specify the character set to be used for processing log files. On Windows, the shared-memory name to use for connections made using shared memory to a local server. The default value is  MYSQL . The shared-memory name is case-sensitive. This option applies only if the server was started with the  shared_memory  system variable enabled to support shared-memory connections. Display only the statements contained in the log, without any extra information or row-based events. This is for testing only, and should not be used in production systems. It is deprecated, and you should expect it to be removed in a future release. Do not display any GTIDs in the output. This is needed when writing to a dump file from one or more binary logs containing GTIDs, as shown in this example: The use of this option is otherwise not normally recommended in production. For connections to  localhost , the Unix socket file to use, or, on Windows, the name of the named pipe to use. On Windows, this option applies only if the server was started with the  named_pipe  system variable enabled to support named-pipe connections. In addition, the user making the connection must be a member of the Windows group specified by the  named_pipe_full_access_group  system variable. Options that begin with  --ssl  specify whether to connect to the server using encryption and indicate where to find SSL keys and certificates. See Command Options for Encrypted Connections. 613 • --ssl* • --socket= path ,  -S  path • --skip-gtids[=(true|false)] • --short-form ,  -s • --shared-memory-base-name= name • --set-charset= charset_name mysqlbinlog --skip-gtids binlog.000001 > /tmp/dump.sql mysqlbinlog --skip-gtids binlog.000002 >> /tmp/dump.sql mysql -u root -p -e "source /tmp/dump.sql"