恢复数据:
1.前提是开启了binlog
/usr/bin/mysqlbinlog --start-date='2014-06-01 00:00:00' --stop-date='2014-06-28 23:59:59’ /data/mysql/mysql-bin.000018 >/data/backup/mysql/mysql_restore_2040628.sql
#全库导出
/usr/bin/mysqlbinlog /data/mysql/mysql-bin.000018 >/data/backup/mysql/mysql_restore_2040628.sql
#导入临时库
create database backup;
use backup;
source /data/backup/mysql/mysql_restore_2040628.sql;
