-
mkdir -p /data/backup_binlog
mysqlbinlog -h$ip -P$port -u$user -p$password -R –raw –stop-never mysql-bin.000008 -r /data/backup_binlog/ &
-
[root@sAno1ybackup_binlog]# mysql -h$ip -P$port -u$user -p$password -e “SHOW BINARY LOGS”
mysql: [Warning] Using a password on the command line interface can be insecure.
+——————+————+
| Log_name | File_size |
+——————+————+
| mysql-bin.000008 | 1073742873 |
| mysql-bin.000009 | 284594590 |
| mysql-bin.000010 | 396303459 |
| mysql-bin.000011 | 154 |
| mysql-bin.000012 | 154 |
| mysql-bin.000013 | 154 |
+——————+————+
检查拉取过来的binlog，与show binary logs结果一致。
[root@sAno1ybackup_binlog]# ll
total 1713580
-rw-r—– 1 root root 1073742873 Aug 22 17:12 mysql-bin.000008
-rw-r—– 1 root root 284594590 Aug 22 17:13 mysql-bin.000009
-rw-r—– 1 root root 396303459 Aug 22 17:13 mysql-bin.000010
-rw-r—– 1 root root 154 Aug 22 17:13 mysql-bin.000011
-rw-r—– 1 root root 154 Aug 22 17:13 mysql-bin.000012
-rw-r—– 1 root root 154 Aug 22 17:13 mysql-bin.000013
：http://www.linuxidc.com/Linux/2017-09/146649.htm
