xtrabackup增量备份方案，备份恢复全过程记录(三)
lready prepared.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(893330821)
xtrabackup: page size for /data/back_up/delta//ibdata1.delta is 16384 bytes
Applying /data/back_up/delta//ibdata1.delta ...
xtrabackup: page size for /data/back_up/delta//inno/mm.ibd.delta is 16384 bytes
Applying /data/back_up/delta//inno/mm.ibd.delta ...
xtrabackup: page size for /data/back_up/delta//inno/t.ibd.delta is 16384 bytes
Applying /data/back_up/delta//inno/t.ibd.delta ...
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = /data/back_up/delta/
xtrabackup: innodb_log_files_in_group = 1
xtrabackup: innodb_log_file_size = 2097152
130327 14:42:49 InnoDB: Using Linux native AIO
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
130327 14:42:49 InnoDB: The InnoDB memory heap is disabled
130327 14:42:49 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
130327 14:42:49 InnoDB: Compressed tables use zlib 1.2.3
130327 14:42:49 InnoDB: Using Linux native AIO
130327 14:42:49 InnoDB: Warning: innodb_file_io_threads is deprecated. Please use innodb_read_io_threads and innodb_write_io_threads instead
130327 14:42:49 InnoDB: Initializing buffer pool, size = 100.0M
130327 14:42:49 InnoDB: Completed initialization of buffer pool
130327 14:42:49 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130327 14:42:49 InnoDB: Database was not shut down normally!
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Last MySQL binlog file position 0 474, file name ./mysql-bin.000005
130327 14:42:49 InnoDB: Waiting for the background threads to start
130327 14:42:50 InnoDB: 1.1.5 started; log sequence number 893330821
[notice (again)]
If you use binary log and don't use any hack of group commit,
the binary log position seems to be:
InnoDB: Last MySQL binlog file position 0 474, file name ./mysql-bin.000005
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
130327 14:42:50 InnoDB: Starting shutdown...
130327 14:42:51 InnoDB: Shutdown completed; log sequence number 893330821
[root@Slave02 delta]#
[root@Slave02 data]# rm -rf inno/ ----删除数据目录中的inno库的所有文件
[root@Slave02 data]# ls
book mysql mysql-bin.000005 prod
ibdata1 mysql-bin.000001 mysql-bin.index Slave02.err
ib_logfile0 mysql-bin.000002 mysqld_multi.log Slave02.pid
ib_logfile1 mysql-bin.000003 mysql.pid slow.log
log.1 mysql-bin.000004 performance_schema test
[root@Slave02 data]# cp -r /data/back_up/inno/ /usr/local/mysql/data/ ---从备份目录中拷贝全备的相关文件到
数据库目录中去
[root@Slave02 data]# cd inno/
[root@Slave02 inno]# ll
total 2096
-rw-r----- 1 root root 8554 Mar 27 14:49 mm.frm
-rw-r--r-- 1 root root 1048576 Mar 27 14:49 mm.ibd
-rw-r----- 1 root root 8554 Mar 27 14:49 t.frm
-rw-r--r-- 1 root root 1