Long Form

Short Form

Description

Default Value

--backup-id

-b

Backup sequence ID

0

--backup_path

None

Path to backup files

./

--character-sets-dir

None

Specify the directory where character set information can be found

None

--connect, --connectstring, or --ndb-connectstring

-c or -C

Set the connectstring in [nodeid=node_id;][host=]host[:port] format

localhost:1186

--core-file

None

Write a core file in the event of an error

TRUE

--debug

-#

Output debug log

d:t:O,/tmp/ndb_restore.trace

--dont_ignore_systab_0

-f

Do not ignore system table during restore — EXPERIMENTAL; not for production use

FALSE

--help or –usage

-?

Display help message with available options and current values, then exit

[N/A]

--ndb-mgmd-host

None

Set the host and port in host[:port] format for the management server to connect to; this is the same as --connect, --connectstring, or --ndb-connectstring, but without a way to specify the nodeid

None

--ndb-nodegroup-map

-z

Specifies a nodegroup map — Syntax: list of (source_nodegroup, destination_nodegroup)

None

--ndb-nodeid

None

Specify a node ID for the ndb_restore process

0

--ndb-optimized-node-selection

None

Optimize selection of nodes for transactions

TRUE

--ndb-shm

None

Use shared memory connections when available

FALSE

--no-restore-disk-objects

-d

Do not restore disk data object such as tablespaces and log file groups

FALSE (in other words, restore disk data object unless this option is used)

--nodeid

-n

Use backup files from node with the specified ID

0

--parallelism

-p

Set from 1 to 1024 parallel transactions to be used during the restoration process

128

--print

None

Print metadata and log to stdout

FALSE

--print_data

None

Print data to stdout

FALSE

--print_log

None

Print log to stdout

FALSE

--print_meta

None

Print metadata to stdout

FALSE

--restore_data

-r

Restore data and logs

FALSE

--restore_epoch

-e

Restore epoch data into the status table; the row in the cluster.apply_status having the id 0 is inserted or updated as appropriate — this is convenient when starting up replication on a MySQL cluster replication slave

FALSE

--restore_meta

-m

Restore table metadata

FALSE

--skip-table-check

-s

Do not check table schemas (Added in MySQL 5.1.17; not supported in MySQL cluster 5.1Carrier Grade Edition

FALSE

--version

-V

Output version information and exit

[N/A]

Long Form

Short Form

Description

Default Value

--tab

-T

Creates dumpfiles, one per table, each named tbl_name.txt. Takes as its argument the path to the directory where the files should be saved (required; use . for the current directory).

None

--fields-enclosed-by

None

String used to enclose all column values

None

--fields-optionally-enclosed-by

None

String used to enclose column values containing character data (such as CHAR, VARCHAR, BINARY, TEXT, or ENUM)

None

--fields-terminated-by

None

String used to separate column values

\t (tab character)

--hex

None

Use hex format for binary values

[N/A]

--lines-terminated-by

None

String used to terminate each line

\n (linefeed character)

--appends

None

When used with --tab, causes the data to be appended to existing files of the same name

[N/A]