Command Line 1 tried ==================== [mysql@server01 bin]$ ./innobackupex --user=dbabackup --defaults-file=/usr/local/mysql/mysql5530/my.cnf /mysqldb/backups/MYINS InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved. This software is published under the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. Get the latest version of Percona XtraBackup, documentation, and help resources: http://www.percona.com/xb/p 140130 14:47:33 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/usr/local/mysql/mysql5530/my.cnf;mysql_read_default_group=xtrabackup' as 'dbabackup' (using password: NO). 140130 14:47:33 innobackupex: Connected to MySQL server 140130 14:47:33 innobackupex: Executing a version check against the server... 140130 14:47:33 innobackupex: Done. IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". innobackupex: Using mysql server version 5.5.30-enterprise-commercial-advanced-log innobackupex: Created backup directory /mysqldb/backups/MYINS/2014-01-30_14-47-33 140130 14:47:33 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-file="/usr/local/mysql/mysql5530/my.cnf" --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/mysqldb/backups/MYINS/2014-01-30_14-47-33 --tmpdir=/tmp innobackupex: Waiting for ibbackup (pid=2225) to suspend innobackupex: Suspend file '/mysqldb/backups/MYINS/2014-01-30_14-47-33/xtrabackup_suspended_2' Open source backup tool for InnoDB and XtraDB Copyright (C) 2009-2013 Percona LLC and/or its affiliates. Portions Copyright (C) 2000, 2011, MySQL AB & Innobase Oy. All Rights Reserved. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation version 2 of the License. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You can download full text of the license on http://www.gnu.org/licenses/gpl-2.0.txt Usage: [xtrabackup_55 [--defaults-file=#] --backup | xtrabackup_55 [--defaults-file=#] --prepare] [OPTIONS] Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf /usr/local/mysql/mysql5530/my.cnf ~/.my.cnf The following groups are read: mysqld xtrabackup mysqld The following options may be given as the first argument: --print-defaults Print the program argument list and exit. --no-defaults Don't read default options from any option file. --defaults-file=# Only read default options from the given file #. --defaults-extra-file=# Read this file after the global files are read. -v, --version print xtrabackup version information --target-dir=name destination directory --backup take backup to target-dir --stats calc statistic of datadir (offline mysqld is recommended) --prepare prepare a backup for starting mysql server on the backup. --export create files to import to another database when prepare. --apply-log-only stop recovery process not to progress LSN after applying log when prepare. --print-param print parameter of mysqld needed for copyback. --use-memory=# The value is used instead of buffer_pool_size --suspend-at-start creates a file 'xtrabackup_suspended_1' and waits until the user deletes that file after the background log copying thread is started during backup --suspend-at-end creates a file 'xtrabackup_suspended_2' and waits until the user deletes that file at the end of '--backup' --throttle=# limit count of IO operations (pairs of read&write) per second to IOS values (for '--backup') --log-copy-interval=# time interval between checks done by log copying thread in milliseconds (default is 1 second). --extra-lsndir=name (for --backup): save an extra copy of the xtrabackup_checkpoints file in this directory. --incremental-lsn=name (for --backup): copy only .ibd pages newer than specified LSN 'high:low'. ##ATTENTION##: If a wrong LSN value is specified, it is impossible to diagnose this, causing the backup to be unusable. Be careful! --incremental-basedir=name (for --backup): copy only .ibd pages newer than backup at specified directory. --incremental-dir=name (for --prepare): apply .delta files and logfile in the specified directory. --tables=name filtering by regexp for table names. --tables-file=name filtering by list of the exact database.table name in the file. --create-ib-logfile ** not work for now** creates ib_logfile* also after '--prepare'. ### If you want create ib_logfile*, only re-execute this command in same options. ### -h, --datadir=name Path to the database root. -t, --tmpdir=name Path for temporary files. Several paths may be specified, separated by a colon (:), in this case they are used in a round-robin fashion. --parallel=# Number of threads to use for parallel datafiles transfer. Does not have any effect in the stream mode. The default value is 1. --stream=name Stream all backup files to the standard output in the specified format. Currently the only supported format is 'tar'. --compress[=name] Compress individual backup files using the specified compression algorithm. Currently the only supported algorithm is 'quicklz'. It is also the default algorithm, i.e. the one used when --compress is used without an argument. --compress-threads=# Number of threads for parallel data compression. The default value is 1. --compress-chunk-size=# Size of working buffer(s) for compression threads in bytes. The default value is 64K. --encrypt=name Encrypt individual backup files using the specified encryption algorithm. --encrypt-key=name Encryption key to use. --encrypt-key-file=name File which contains encryption key to use. --encrypt-threads=# Number of threads for parallel data encryption. The default value is 1. --encrypt-chunk-size=# Size of working buffer(S) for encryption threads in bytes. The default value is 64K. --innodb[=name] Ignored option for MySQL option compatibility --innodb-adaptive-hash-index Enable InnoDB adaptive hash index (enabled by default). Disable with --skip-innodb-adaptive-hash-index. (Defaults to on; use --skip-innodb-adaptive-hash-index to disable.) --innodb-additional-mem-pool-size=# Size of a memory pool InnoDB uses to store data dictionary information and other internal data structures. --innodb-autoextend-increment=# Data file autoextend increment in megabytes --innodb-buffer-pool-size=# The size of the memory buffer InnoDB uses to cache data and indexes of its tables. --innodb-checksums Enable InnoDB checksums validation (enabled by default). Disable with --skip-innodb-checksums. (Defaults to on; use --skip-innodb-checksums to disable.) --innodb-data-file-path=name Path to individual files and their sizes. --innodb-data-home-dir=name The common part for InnoDB table spaces. --innodb-doublewrite Enable InnoDB doublewrite buffer (enabled by default). Disable with --skip-innodb-doublewrite. (Defaults to on; use --skip-innodb-doublewrite to disable.) --innodb-io-capacity[=#] Number of IOPs the server can do. Tunes the background IO rate --innodb-file-io-threads=# Number of file I/O threads in InnoDB. --innodb-read-io-threads=# Number of background read I/O threads in InnoDB. --innodb-write-io-threads=# Number of background write I/O threads in InnoDB. --innodb-file-per-table Stores each InnoDB table to an .ibd file in the database dir. --innodb-flush-log-at-trx-commit[=#] Set to 0 (write and flush once per second), 1 (write and flush at each commit) or 2 (write at commit, flush once per second). --innodb-flush-method=name With which method to flush data. --innodb-force-recovery=# Helps to save your data in case the disk image of the database becomes corrupt. --innodb-lock-wait-timeout=# Timeout in seconds an InnoDB transaction may wait for a lock before being rolled back. --innodb-log-buffer-size=# The size of the buffer which InnoDB uses to write log to the log files on disk. --innodb-log-file-size=# Size of each log file in a log group. --innodb-log-files-in-group=# Number of log files in the log group. InnoDB writes to the files in a circular fashion. Value 3 is recommended here. --innodb-log-group-home-dir=name Path to InnoDB log files. --innodb-max-dirty-pages-pct=# Percentage of dirty pages allowed in bufferpool. --innodb-open-files=# How many files at the maximum InnoDB keeps open at the same time. --innodb-use-native-aio Use native AIO if supported on this platform. --innodb-page-size=# The universal page size of the database. --innodb-log-block-size=# The log block size of the transaction log file. Changing for created log file is not supported. Use on your own risk! --innodb-fast-checksum Change the algorithm of checksum for the whole of datapage to 4-bytes word based. --innodb-extra-undoslots Enable to use about 4000 undo slots instead of default 1024. Not recommended to use, Because it is not change back to disable, once it is used. --innodb-doublewrite-file=name Path to special datafile for doublewrite buffer. (default is : not used) --innodb-buffer-pool-filename=name Filename to/from which to dump/load the InnoDB buffer pool --debug-sync=name Debug sync point. This is only used by the xtrabackup test suite --compact Create a compact backup by skipping secondary index pages. --rebuild-indexes Rebuild secondary indexes in InnoDB tables after applying the log. Only has effect with --prepare. --rebuild-threads=# Use this number of threads to rebuild indexes in a compact backup. Only has effect with --prepare and --rebuild-indexes. --incremental-force-scan Perform a full-scan incremental backup even in the presence of changed page bitmap data --defaults-group=name defaults group in config file (default "mysqld"). Variables (--variable-name=value) and boolean options {FALSE|TRUE} Value (after reading options) --------------------------------- ---------------------------------------- version FALSE target-dir /mysqldb/backups/MYINS/2014-01-30_14-47-33 backup TRUE stats FALSE prepare FALSE export FALSE apply-log-only FALSE print-param FALSE use-memory 104857600 suspend-at-start FALSE suspend-at-end TRUE throttle 0 log-copy-interval 1000 extra-lsndir (No default value) incremental-lsn (No default value) incremental-basedir (No default value) incremental-dir (No default value) tables (No default value) tables-file (No default value) create-ib-logfile FALSE datadir ./ tmpdir /tmp parallel 1 stream (No default value) compress (No default value) compress-threads 1 compress-chunk-size 65536 encrypt NONE encrypt-key (No default value) encrypt-key-file (No default value) encrypt-threads 1 encrypt-chunk-size 65536 innodb (No default value) innodb-adaptive-hash-index TRUE innodb-additional-mem-pool-size 1048576 innodb-autoextend-increment 8 innodb-buffer-pool-size 8388608 innodb-checksums TRUE innodb-data-file-path (No default value) innodb-data-home-dir (No default value) innodb-doublewrite TRUE innodb-io-capacity 200 innodb-file-io-threads 4 innodb-read-io-threads 4 innodb-write-io-threads 4 innodb-file-per-table FALSE innodb-flush-log-at-trx-commit 1 innodb-flush-method (No default value) innodb-force-recovery 0 innodb-lock-wait-timeout 50 innodb-log-buffer-size 1048576 innodb-log-file-size 5242880 innodb-log-files-in-group 2 innodb-log-group-home-dir (No default value) innodb-max-dirty-pages-pct 90 innodb-open-files 300 innodb-use-native-aio FALSE innodb-page-size 16384 innodb-log-block-size 512 innodb-fast-checksum FALSE innodb-extra-undoslots FALSE innodb-doublewrite-file (No default value) innodb-buffer-pool-filename (No default value) debug-sync (No default value) compact FALSE rebuild-indexes FALSE rebuild-threads 1 incremental-force-scan FALSE defaults-group mysqld