Recovery By time
Recovery By time:
using the mysqlbinlog utility,We can recover data from the binary log files, starting from a specified point in time until the present or another specified point in time.To restore data from a binary log, you must know the location and name of the current binary log file.Using SHOW BINLOG EVENTS\G statement, we can determine the name of the current binary log file.To specify the time to recover data, We can use following command:
mysqlbinlog –stop-date=[date] /var/log/mysql/bin | mysql -u root -p
