MySQL 9.3 Reference Manual Including MySQL NDB Cluster 9.3
ndb_move_data copies data from one NDB table to another.
The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. Both tables must use the NDB storage engine.
ndb_move_dataoptionssourcetarget
Options that can be used with ndb_move_data are shown in the following table. Additional descriptions follow the table.
| Command-Line Format | --abort-on-error |
|---|
Dump core on permanent error (debug option).
--character-sets-dir=name
| Command-Line Format | --character-sets-dir=path |
|---|---|
| Type | String |
| Default Value | [none] |
Directory where character sets are.
| Command-Line Format | --connect-retry-delay=# |
|---|---|
| Type | Integer |
| Default Value | 5 |
| Minimum Value | 0 |
| Maximum Value | 5 |
Number of seconds to wait between attempts to contact management server.
| Command-Line Format | --connect-retries=# |
|---|---|
| Type | Integer |
| Default Value | 12 |
| Minimum Value | 0 |
| Maximum Value | 12 |
Number of times to retry connection before giving up.
| Command-Line Format | --connect-string=connection_string |
|---|---|
| Type | String |
| Default Value | [none] |
Same as
--ndb-connectstring.
| Command-Line Format | --core-file |
|---|
Write core file on error; used in debugging.
--database=dbname,
-d
| Command-Line Format | --database=name |
|---|---|
| Type | String |
| Default Value | TEST_DB |
Name of the database in which the table is found.
| Command-Line Format | --defaults-extra-file=path |
|---|---|
| Type | String |
| Default Value | [none] |
Read given file after global files are read.
| Command-Line Format | --defaults-file=path |
|---|---|
| Type | String |
| Default Value | [none] |
Read default options from given file only.
| Command-Line Format | --defaults-group-suffix=string |
|---|---|
| Type | String |
| Default Value | [none] |
Also read groups with concat(group, suffix).
| Command-Line Format | --drop-source |
|---|
Drop source table after all rows have been moved.
| Command-Line Format | --error-insert |
|---|
Insert random temporary errors (testing option).
| Command-Line Format | --exclude-missing-columns |
|---|
Ignore extra columns in source or target table.
| Command-Line Format | --help |
|---|
Display help text and exit.
| Command-Line Format | --login-path=path |
|---|---|
| Type | String |
| Default Value | [none] |
Read given path from login file.
| Command-Line Format | --no-login-paths |
|---|
Skips reading options from the login path file.
| Command-Line Format | --lossy-conversions |
|---|
Allow attribute data to be truncated when converted to a smaller type.
| Command-Line Format | --ndb-connectstring=connection_string |
|---|---|
| Type | String |
| Default Value | [none] |
Set connection string for connecting to
ndb_mgmd. Syntax:
[nodeid=.
Overrides entries in id;][host=]hostname[:port]NDB_CONNECTSTRING
and my.cnf.
| Command-Line Format | --ndb-mgm-tls=level |
|---|---|
| Type | Enumeration |
| Default Value | relaxed |
| Valid Values |
|
Sets the level of TLS support required to connect to the
management server; one of relaxed or
strict. relaxed (the
default) means that a TLS connection is attempted, but
success is not required; strict means
that TLS is required to connect.
| Command-Line Format | --ndb-mgmd-host=connection_string |
|---|---|
| Type | String |
| Default Value | [none] |
Same as
--ndb-connectstring.
| Command-Line Format | --ndb-nodeid=# |
|---|---|
| Type | Integer |
| Default Value | [none] |
Set node ID for this node, overriding any ID set by
--ndb-connectstring.
--ndb-optimized-node-selection
| Command-Line Format | --ndb-optimized-node-selection |
|---|
Enable optimizations for selection of nodes for
transactions. Enabled by default; use
--skip-ndb-optimized-node-selection to
disable.
| Command-Line Format | --ndb-tls-search-path=list |
|---|---|
| Type | Path name |
| Default Value (Unix) | $HOME/ndb-tls |
| Default Value (Windows) | $HOMEDIR/ndb-tls |
Specify a list of directories to search for a CA file. On
Unix platforms, the directory names are separated by colons
(:); on Windows systems, the semicolon
character (;) is used as the separator. A
directory reference may be relative or absolute; it may
contain one or more environment variables, each denoted by a
prefixed dollar sign ($), and expanded
prior to use.
Searching begins with the leftmost named directory and
proceeds from left to right until a file is found. An empty
string denotes an empty search path, which causes all
searches to fail. A string consisting of a single dot
(.) indicates that the search path
limited to the current working directory.
If no search path is supplied, the compiled-in default value
is used. This value depends on the platform used: On
Windows, this is \ndb-tls; on other
platforms (including Linux), it is
$HOME/ndb-tls. This can be overridden by
compiling NDB Cluster using
-DWITH_NDB_TLS_SEARCH_PATH.
| Command-Line Format | --no-defaults |
|---|
Do not read default options from any option file other than login file.
| Command-Line Format | --print-defaults |
|---|
Print program argument list and exit.
| Command-Line Format | --promote-attributes |
|---|
Allow attribute data to be converted to a larger type.
--staging-tries=x[,y[,z]]
| Command-Line Format | --staging-tries=x[,y[,z]] |
|---|---|
| Type | String |
| Default Value | 0,1000,60000 |
Specify tries on temporary errors. Format is x[,y[,z]] where x=max tries (0=no limit), y=min delay (ms), z=max delay (ms).
| Command-Line Format | --usage |
|---|
Display help text and exit; same as
--help.
| Command-Line Format | --verbose |
|---|
Enable verbose messages.
| Command-Line Format | --version |
|---|
Display version information and exit.