恢复使用MEB备份的MySQL数据库，执行一个普通备份
| [root@test bin]# ./mysqlbackup --defaults-file=/service/mysql5.5/my.cnf --socket=/data/mysql5.5/mysql.sock --user=root --backup-dir=/backup/5.5/normal --password backupMySQL Enterprise Backup version 3.8.2 [2013/06/18]Copyright (c) 2003, 2012,Oracle and/or its affiliates. All Rights Reserved.mysqlbackup: INFO: Starting with following command line ..../mysqlbackup --defaults-file=/service/mysql5.5/my.cnf--socket=/data/mysql5.5/mysql.sock --user=root--backup-dir=/backup/5.5/normal --password backupEnter password:mysqlbackup: INFO: MySQL server version is '5.5.25-log'.mysqlbackup: INFO: Got some server configuration information from running server.IMPORTANT: Please check that mysqlbackup run completes successfully.At the end of a successful 'backup' run mysqlbackupprints "mysqlbackup completed OK!". |
--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
| datadir = /data/mysql5.5/innodb_data_home_dir =innodb_data_file_path = ibdata1:10M:autoextendinnodb_log_group_home_dir = /data/mysql5.5/innodb_log_files_in_group = 3innodb_log_file_size = 536870912innodb_page_size = Nullinnodb_checksum_algorithm = innodb |
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
| datadir = /backup/5.5/normal/datadirinnodb_data_home_dir = /backup/5.5/normal/datadirinnodb_data_file_path = ibdata1:10M:autoextendinnodb_log_group_home_dir = /backup/5.5/normal/datadirinnodb_log_files_in_group = 3innodb_log_file_size = 536870912innodb_page_size = 16384innodb_checksum_algorithm = innodbmysqlbackup: INFO: Unique generated backup id for this is 13851351066141087mysqlbackup: INFO: Uses posix_fadvise() for performance optimization.mysqlbackup: INFO: Creating 14 buffers each of size 16777216.131122 23:45:08 mysqlbackup: INFO: Full Backup operation starts with following threads1 read-threads 6 process-threads 1 write-threads131122 23:45:08 mysqlbackup: INFO: System tablespace file format is Antelope.131122 23:45:08 mysqlbackup: INFO: Starting to copy all innodb files...131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/ibdata1 (Antelope file format).131122 23:45:08 mysqlbackup: INFO: Found checkpoint at lsn 3406087628.131122 23:45:08 mysqlbackup: INFO: Starting log scan from lsn 3406087168.131122 23:45:08 mysqlbackup: INFO: Copying log...131122 23:45:08 mysqlbackup: INFO: Log copied, lsn 3406087628.131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_qs_variables.ibd (Antelope file format).131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_script_report_data.ibd (Antelope file format).131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_split_column_names_table.ibd (Antelope file format).131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_sql_tokens.ibd (Antelope file format).131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_known_thread_states.ibd (Antelope file format).131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_named_scripts.ibd (Antelope file format).131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_script_statements.ibd (Antelope file format).131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_waits.ibd (Antelope file format).131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/help_content.ibd (Antelope file format).131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/metadata.ibd (Antelope file format).131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/numbers.ibd (Antelope file format).131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/zwc/t2.ibd (Antelope file format).mysqlbackup: Progress in MB: 200 400131122 23:45:20 mysqlbackup: INFO: Completing the copy of innodb files.131122 23:45:21 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.131122 23:45:21 mysqlbackup: INFO: Starting to lock all the tables...131122 23:45:21 mysqlbackup: INFO: All tables are locked and flushed to disk131122 23:45:21 mysqlbackup: INFO: Opening backup source directory '/data/mysql5.5/'131122 23:45:21 mysqlbackup: INFO: Starting to backup all non-innodb files insubdirectories of '/data/mysql5.5/'131122 23:45:21 mysqlbackup: INFO: Copying the database directory 'common_schema'131122 23:45:21 mysqlbackup: INFO: Copying the database directory 'mysql'131122 23:45:21 mysqlbackup: INFO: Copying the database directory 'performance_schema'131122 23:45:21 mysqlbackup: INFO: Copying the database directory 'test'131122 23:45:21 mysqlbackup: INFO: Copying the database directory 'zwc'mysqlbackup: Progress in MB: 600 800131122 23:45:33 mysqlbackup: INFO: Completing the copy of all non-innodb files.131122 23:45:35 mysqlbackup: INFO: A copied database page was modified at 3406087628.(This is the highest lsn found on page)Scanned log up to lsn 3406090810.Was able to parse the log up to lsn 3406090810.Maximum page number for a log record 315131122 23:45:35 mysqlbackup: INFO: All tables unlocked131122 23:45:35 mysqlbackup: INFO: All MySQL tables were locked for 13.758 seconds.131122 23:45:35 mysqlbackup: INFO: Full Backup operation completed successfully.131122 23:45:35 mysqlbackup: INFO: Backup created in directory '/backup/5.5/normal'131122 23:45:35 mysqlbackup: INFO: MySQL binlog position: filename ZWC-TEST.000024, position 16178-------------------------------------------------------------Parameters Summary -------------------------------------------------------------Start LSN : 3406087168End LSN : 3406090810-------------------------------------------------------------mysqlbackup completed OK! |
