mysqlbinlog 做实时增量备份是很有必要的,公司开发层误删过整个data目录,如果没有对binlog做实时备份。也没有从库的环境下,恢复也是很麻烦的。有了binlog再结合全备做基于时间点的恢复还是很方便的。
用法:
mkdir -p /backup_binlog mysqlbinlog -h56.56.56.207 -P3306 -ubackup -p123456 -R --raw --stop-never mysql-bin.000003 -r /backup_binlog/ &
[root@mysql_duizhang ~]# mysql -uroot -p123456 -e "show binary logs"
mysql: [Warning] Using a password on the command line interface can be insecure.
+------------------+-----------+
| Log_name | File_size |
+------------------+-----------+
| mysql-bin.000001 | 177 |
| mysql-bin.000002 | 93166 |
| mysql-bin.000003 | 1266693 |
| mysql-bin.000004 | 1190364 |
+------------------+-----------+
可以看到,把从3开始的b
用法:
mkdir -p /backup_binlog mysqlbinlog -h56.56.56.207 -P3306 -ubackup -p123456 -R --raw --stop-never mysql-bin.000003 -r /backup_binlog/ &
[root@mysql_duizhang ~]# mysql -uroot -p123456 -e "show binary logs"
mysql: [Warning] Using a password on the command line interface can be insecure.
+------------------+-----------+
| Log_name | File_size |
+------------------+-----------+
| mysql-bin.000001 | 177 |
| mysql-bin.000002 | 93166 |
| mysql-bin.000003 | 1266693 |
| mysql-bin.000004 | 1190364 |
+------------------+-----------+
可以看到,把从3开始的b