Documentation Home
MySQL Enterprise Backup 3.7 User's Guide
Download this Manual
PDF (US Ltr) - 0.8Mb
PDF (A4) - 0.8Mb


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.

  • only-innodb-with-frm

    Back up only InnoDB data, log files, and .frm files associated with InnoDB tables. Same as the --only-innodb-with-frm 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.

  • incremental-with-redo-log-only

    Performs an incremental backup. Same as the --incremental-with-redo-log-only option.

  • incremental-base

    Specifies the location of a previous incremental backup, to automatically retrieve the LSN to use as the starting point for the next one. Same as the --incremental-base 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.


User Comments
Sign Up Login You must be logged in to post a comment.