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.
Table 23.37 Command-line options used with the program ndb_move_data
| Format | Description | Added, Deprecated, or Removed |
|---|---|---|
| Dump core on permanent error (debug option) | (Supported in all NDB releases based on MySQL 8.0) |
|
| Directory where character sets are | (Supported in all NDB releases based on MySQL 8.0) |
|
| Number of times to retry connection before giving up | (Supported in all NDB releases based on MySQL 8.0) |
|
| Number of seconds to wait between attempts to contact management server | (Supported in all NDB releases based on MySQL 8.0) |
|
| Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 8.0) |
|
| Write core file on error; used in debugging | (Supported in all NDB releases based on MySQL 8.0) |
|
| Name of database in which table is found | (Supported in all NDB releases based on MySQL 8.0) |
|
| Read given file after global files are read | (Supported in all NDB releases based on MySQL 8.0) |
|
| Read default options from given file only | (Supported in all NDB releases based on MySQL 8.0) |
|
| Also read groups with concat(group, suffix) | (Supported in all NDB releases based on MySQL 8.0) |
|
| Drop source table after all rows have been moved | (Supported in all NDB releases based on MySQL 8.0) |
|
| Insert random temporary errors (testing option) | (Supported in all NDB releases based on MySQL 8.0) |
|
| Ignore extra columns in source or target table | (Supported in all NDB releases based on MySQL 8.0) |
|
| Display help text and exit | (Supported in all NDB releases based on MySQL 8.0) |
|
| Read given path from login file | (Supported in all NDB releases based on MySQL 8.0) |
|
| Allow attribute data to be truncated when converted to smaller type | (Supported in all NDB releases based on MySQL 8.0) |
|
| Set connect string for connecting to ndb_mgmd. Syntax: "[nodeid=id;][host=]hostname[:port]". Overrides entries in NDB_CONNECTSTRING and my.cnf | (Supported in all NDB releases based on MySQL 8.0) |
|
| Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 8.0) |
|
| Set node ID for this node, overriding any ID set by --ndb-connectstring | (Supported in all NDB releases based on MySQL 8.0) |
|
| Enable optimizations for selection of nodes for transactions. Enabled by default; use --skip-ndb-optimized-node-selection to disable | (Supported in all NDB releases based on MySQL 8.0) |
|
| Do not read default options from any option file other than login file | (Supported in all NDB releases based on MySQL 8.0) |
|
| Print program argument list and exit | (Supported in all NDB releases based on MySQL 8.0) |
|
| Allow attribute data to be converted to larger type | (Supported in all NDB releases based on MySQL 8.0) |
|
| 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) | (Supported in all NDB releases based on MySQL 8.0) |
|
| Display help text and exit; same as --help | (Supported in all NDB releases based on MySQL 8.0) |
|
| Enable verbose messages | (Supported in all NDB releases based on MySQL 8.0) |
|
| Display version information and exit | (Supported in all NDB releases based on MySQL 8.0) |
| Command-Line Format | --abort-on-error |
|---|---|
| Type | Boolean |
| Default Value | FALSE |
Dump core on permanent error (debug option).
| Command-Line Format | --character-sets-dir=name |
|---|---|
| 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.
| Command-Line Format | --database=dbname |
|---|---|
| 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 |
|---|---|
| Type | Boolean |
| Default Value | FALSE |
Drop source table after all rows have been moved.
| Command-Line Format | --error-insert |
|---|---|
| Type | Boolean |
| Default Value | FALSE |
Insert random temporary errors (testing option).
| Command-Line Format | --exclude-missing-columns |
|---|---|
| Type | Boolean |
| Default Value | FALSE |
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 | --lossy-conversions |
|---|---|
| Type | Boolean |
| Default Value | FALSE |
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 connect string for connecting to ndb_mgmd. Syntax: "[nodeid=id;][host=]hostname[:port]". Overrides entries in NDB_CONNECTSTRING and my.cnf.
| 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 | --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 |
|---|---|
| Type | Boolean |
| Default Value | FALSE |
Allow attribute data to be converted to a larger type.
| 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 |
|---|---|
| Type | Boolean |
| Default Value | FALSE |
Enable verbose messages.
| Command-Line Format | --version |
|---|
Display version information and exit.