› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
xiaoyanbot
V2EX  ›  MySQL

执行 mysqlbinlog.exe d:\mysql-bin.000024 --base64-output=decode-rows 发现没有显示全,怎么破?

  •  
  •   xiaoyanbot · Jun 25, 2021 · 1890 views
    This topic created in 1926 days ago, the information mentioned may be changed or developed.

    mysql-bin.000024 手工打开的情况看, 有 8MB 的文件, 还有很多日志;但是默认没有显示全, 请问需要加什么参数吗?

    或者离线文件状态下,如何查看最大的 position 呢?

    xiaoyanbot
        1
    xiaoyanbot  
    OP
       Jun 25, 2021
    好像这样就显示全了:

    mysqlbinlog.exe d:\mysql-bin.000024 --base64-output=decode-rows --result-file=d:\24.sql
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2291 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 21ms · UTC 06:43 · PVG 14:43 · LAX 23:43 · JFK 02:43
    ♥ Do have faith in what you're doing.