바이너리 로그로 복원 (binlog, binary log)

mysqlbinlog --database=sakila /gamevil/database/binlog/mysql-master-bin.000001 | grep -B 3 -i 'drop table sakila.payment'

# at 352

# 070919 16:11:23 server id 1 end_log_pos 429 Query thread_id=16 exec_time=0 error_code=0

SET TIMESTAMP=1190232683/*!*/;

DROP TABLE sakila.payment/*!*/;

server1# mysqlbinlog --database=sakila /gamevil/database/binlog/mysql-master.bin.000001 --stop-position=352 | mysql -uroot -p

server1# mysqlbinlog --database=sakila /gamevil/database/binlog/mysql-master.bin.000001 --start-position=429 | mysql -uroot -p