如何在 Google Cloud SQL 匯出 binlog


 

# mysqlbinlog --base64-output=AUTO --verbose -R -h [CLOUD SQL IP] -u root -p mysql-bin.000199 > /tmp/binlog-dump-000199.sql


MySQL 5.6 開始支援 GTID

需要搭配上面的參數才能將 binlog 解析出 SQL


參考來源:

Show sql statements from mysql binlog (GTID)

Comments

Popular posts from this blog

CentOS7 如何新增/移除 Rich Rule for firewalld

mac 安裝 mtr

如何設定 SSL VPN 分割通道 on Fortigate 80C