MySQL Backup and recovery (Note II)

MySQL Incremental backup
Premise, the server needs to open the binary log
mysql> SHOW BINARY LOGS; View all binary files
mysql> SHOW MASTER STATUS; View current binary files

Mysqlbinlog Instructions for use
Mysqlbinlog A temporary table is generated when importing data, which is especially noticeable in large files, where the temporary table location is an environment variable Tmpdir
The more important parameters are as follows:
--start-datetime start at a point in time
--stop-datetime to a point in time
--start-position start at the specified location point
--stop-position end from the specified location point
--user the specified user
Recover from a specified location
shell> mysqlbinlog--start-position=3831017--stop-position=3831518 mysql-bin.000019 |mysql-uroot-p
shell> mysqlbinlog--stop-datetime= "2016-04-02 9:59:59"/var/log/mysql/bin.123456 | Mysql-u root-p
Please refer to the manual for more parameters
View Binary file contents
Mysqlbinlog Binlog_file | Less
You can also choose to save the file and view it as:
Mysqlbinlog Binlog_file >data.sql

This article is from the "Linux Learning path" blog, so be sure to keep this source http://raystudylinux.blog.51cto.com/9065684/1767034

MySQL Backup and recovery (Note II)