MySQL Compressed Backup
[root@test zwc]# ls -lh total 953M -rw-rw---- 1 mysql mysql 61 Nov 3 22:03 db.opt -rw-rw---- 1 mysql mysql 8.5K Nov 3 22:10 t1.frm -rw-rw---- 1 mysql mysql 191M Nov 3 22:25 t1.MYD -rw-rw---- 1 mysql mysql 295M Nov 3 22:42 t1.MYI -rw-rw---- 1 mysql mysql 8.4K Nov 3 22:11 t2.frm -rw-rw---- 1 mysql mysql 468M Nov 3 22:40 t2.ibd Using MEB normal backup [root@test backup]# time /service/mysql5.5/bin/mysqlbackup --user=root --backup-dir=/backup/meb_normal backup-and-apply-log --socket=/data/mysql5.5/mysql.sock --password MySQL 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 ... /service/mysql5.5/bin/mysqlbackup --user=root --backup-dir=/backup/meb_normal backup-and-apply-log --socket=/data/mysql5.5/mysql.sock --password
Enter password:
mysqlbackup: INFO: MySQL server version is '5.5.25-log'.
mysqlbackup: INFO: Got some server configuration information from running server.
mysqlbackup: INFO: MySQL server version is '5.5.25-log'.
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'backup-and-apply-log' run mysqlbackup
prints "mysqlbackup completed OK!".
At the end of a successful 'backup-and-apply-log' run mysqlbackup
prints "mysqlbackup completed OK!".
--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /data/mysql5.5/
innodb_data_home_dir =
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /data/mysql5.5/
innodb_log_files_in_group = 3
innodb_log_file_size = 536870912
innodb_page_size = Null
innodb_checksum_algorithm = innodb
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /backup/meb_normal/datadir
innodb_data_home_dir = /backup/meb_normal/datadir
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /backup/meb_normal/datadir
innodb_log_files_in_group = 3
innodb_log_file_size = 536870912
innodb_page_size = 16384
innodb_checksum_algorithm = innodb
mysqlbackup: INFO: Unique generated backup id for this is 13834928576619365
mysqlbackup: INFO: Uses posix_fadvise() for performance optimization.
mysqlbackup: INFO: Creating 14 buffers each of size 16777216.
131103 23:34:19 mysqlbackup: INFO: Full Backup operation starts with following threads
1 read-threads 6 process-threads 1 write-threads
131103 23:34:19 mysqlbackup: INFO: System tablespace file format is Antelope.
131103 23:34:19 mysqlbackup: INFO: Starting to copy all innodb files...
131103 23:34:19 mysqlbackup: INFO: Copying /data/mysql5.5/ibdata1 (Antelope file format).
131103 23:34:19 mysqlbackup: INFO: Found checkpoint at lsn 3406071002.
131103 23:34:19 mysqlbackup: INFO: Starting log scan from lsn 3406070784.
131103 23:34:19 mysqlbackup: INFO: Copying log...
131103 23:34:19 mysqlbackup: INFO: Log copied, lsn 3406071002.
131103 23:34:19 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_qs_variables.ibd (Antelope file format).
131103 23:34:19 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_script_report