4.2.3 Other Parameters

compress

Generates a compressed backup. Same as the --compress option.

compress-level

Specifies the level of compression, 0 (none) to 9 (maximum). Same as the --compress-level option.

only-innodb

Back up only InnoDB data and log files. Same as the --only-innodb option.

no-history-logging

Turns off the recording of backup progress and history in logging tables inside the backed-up database. Same as the --no-history-logging option.

no-locking

Disables locking during backup of non-InnoDB files, even if a connection is available. Same as the --no-locking option.

no-connection

Prohibits making a connection to the mysqld server, for compatibility with previous behavior of the ibbackup command. Same as the --no-connection option.

connect-if-online

Use the database connection if possible, but continue using file system operations to copy the data files if a connection cannot be established. Same as the --connect-if-online option.

include

Specifies the regular expression to do a partial backup, including certain InnoDB tables only. Same as the --include option.

with-timestamp

Creates a subdirectory underneath the backup directory, with a name formed from the timestamp of the backup operation. Same as the --with-timestamp option.

slave-info

Assists in setting up a new slave instance using a backup of the master. Same as the --slave-info option. Same as that of existing innobackup option.

databases=list

Space-separated list of non-InnoDB tables from selected databases to back up. Same as the --databases option.

databases-list-file=path

Specifies a file containing names of non-InnoDB tables from selected databases to back up. Same as the --databases-list-file option.

suspend-at-end

Pauses the backup so that you can code your own additional backup steps while the MySQL server is in a read-only state. Same as the --suspend-at-end option.

exec-when-locked="utility arg1 arg2 ..."

Specifies the command to run while the MySQL server is in a read-only state and the backup is suspended. Same as the --exec-when-locked option.

incremental

Performs an incremental backup. Same as the --incremental option.

start-lsn

Specifies the starting point for an incremental backup, in terms of a logical sequence number value. Same as the --start-lsn option.

only-known-file-types

Limits copying of non-InnoDB files to a specific set of file extensions. Same as the --only-known-file-types option.

limit-memory=MB

Specify maximum memory in megabytes that can be used in the apply-log operation. Same as the --limit-memory option.

sleep=MS

Specify the number in milliseconds to sleep after copying a certain amount data. Same as the --sleep option.

comments=string

Stores a user-specified string to identify the backup. Same as the --comments option.

comments-file=path

Stores a user-specified file to identify the backup. Same as the --comments-file option.

src-entry=path

Identifies a file or directory to extract from a single-file backup. Same as the --src-entry option.

dst-entry=path

Specifies the destination for the file or directory extracted from a single-file backup. Same as the --dst-entry option.