PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.3Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL NDB Cluster 7.5
ndb_move_data copies data from one NDB table to another.
Usage
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_dataoptionssourcetargetOptions that can be used withndb_move_data are shown in the following table. Additional descriptions follow the table.
Table 21.35 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 5.7) | |
| Directory where character sets are | (Supported in all NDB releases based on MySQL 5.7) | |
| Number of times to retry connection before giving up | (Supported in all NDB releases based on MySQL 5.7) | |
| Number of seconds to wait between attempts to contact management server | (Supported in all NDB releases based on MySQL 5.7) | |
| Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 5.7) | |
| Write core file on error; used in debugging | (Supported in all NDB releases based on MySQL 5.7) | |
| Name of database in which table is found | (Supported in all NDB releases based on MySQL 5.7) | |
| Read given file after global files are read | (Supported in all NDB releases based on MySQL 5.7) | |
| Read default options from given file only | (Supported in all NDB releases based on MySQL 5.7) | |
| Also read groups with concat(group, suffix) | (Supported in all NDB releases based on MySQL 5.7) | |
| Drop source table after all rows have been moved | (Supported in all NDB releases based on MySQL 5.7) | |
| Insert random temporary errors (used in testing) | (Supported in all NDB releases based on MySQL 5.7) | |
| Ignore extra columns in source or target table | (Supported in all NDB releases based on MySQL 5.7) | |
| Display help text and exit | (Supported in all NDB releases based on MySQL 5.7) | |
| Read given path from login file | (Supported in all NDB releases based on MySQL 5.7) | |
| Allow attribute data to be truncated when converted to smaller type | (Supported in all NDB releases based on MySQL 5.7) | |
| 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 5.7) | |
| Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 5.7) | |
| Set node ID for this node, overriding any ID set by --ndb-connectstring | (Supported in all NDB releases based on MySQL 5.7) | |
| 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 5.7) | |
| Do not read default options from any option file other than login file | (Supported in all NDB releases based on MySQL 5.7) | |
| Print program argument list and exit | (Supported in all NDB releases based on MySQL 5.7) | |
| Allow attribute data to be converted to larger type | (Supported in all NDB releases based on MySQL 5.7) | |
| 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 5.7) | |
| Display help text and exit; same as --help | (Supported in all NDB releases based on MySQL 5.7) | |
| Enable verbose messages | (Supported in all NDB releases based on MySQL 5.7) | |
| Display version information and exit | (Supported in all NDB releases based on MySQL 5.7) |
Command-Line Format --abort-on-errorDump core on permanent error (debug option).
Command-Line Format --character-sets-dir=pathType String Default Value [none]Directory where character sets are.
Command-Line Format --connect-retry-delay=#Type Integer Default Value 5Minimum Value 0Maximum Value 5Number of seconds to wait between attempts to contact management server.
Command-Line Format --connect-retries=#Type Integer Default Value 12Minimum Value 0Maximum Value 12Number of times to retry connection before giving up.
Command-Line Format --connect-string=connection_stringType String Default Value [none]Same as
--ndb-connectstring.Command-Line Format --core-fileWrite core file on error; used in debugging.
Command-Line Format --database=nameType String Default Value TEST_DBName of the database in which the table is found.
Command-Line Format --defaults-extra-file=pathType String Default Value [none]Read given file after global files are read.
Command-Line Format --defaults-file=pathType String Default Value [none]Read default options from given file only.
Command-Line Format --defaults-group-suffix=stringType String Default Value [none]Also read groups with concat(group, suffix).
Command-Line Format --drop-sourceDrop source table after all rows have been moved.
Command-Line Format --error-insertInsert random temporary errors (testing option).
Command-Line Format --exclude-missing-columnsIgnore extra columns in source or target table.
Command-Line Format --helpDisplay help text and exit.
Command-Line Format --login-path=pathType String Default Value [none]Read given path from login file.
Command-Line Format --lossy-conversionsAllow attribute data to be truncated when converted to a smaller type.
Command-Line Format --ndb-connectstring=connection_stringType 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_stringType 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-selectionCommand-Line Format --ndb-optimized-node-selectionEnable optimizations for selection of nodes for transactions. Enabled by default; use
--skip-ndb-optimized-node-selectionto disable.Command-Line Format --no-defaultsDo not read default options from any option file other than login file.
Command-Line Format --print-defaultsPrint program argument list and exit.
Command-Line Format --promote-attributesAllow attribute data to be converted to a larger type.
Command-Line Format --staging-tries=x[,y[,z]]Type String Default Value 0,1000,60000Specify 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 --usageDisplay help text and exit; same as
--help.Command-Line Format --verboseEnable verbose messages.
Command-Line Format --versionDisplay version information and exit.
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.3Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL NDB Cluster 7.5