"Fossies" - the Fresh Open Source Software Archive 
"Fossies" - the Fresh Open Source Software Archive
ndb_move_data − NDB data copy utility
|
ndb_move_data options |
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_data options source target
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
•
−−abort−on−error
Dump core on permanent error (debug option).
•
−−character−sets−dir=name
Directory where character sets are.
•
−−connect−retry−delay
Number of seconds to wait between attempts to contact
management server.
•
−−connect−retries
Number of times to retry connection before giving up.
•
−−connect−string
Same as −−ndb−connectstring.
•
−−core−file
Write core file on error; used in debugging.
•
−−database=dbname, −d
Name of the database in which the table is found.
•
−−defaults−extra−file
Read given file after global files are read.
•
−−defaults−file
Read default options from given file only.
•
−−defaults−group−suffix
Also read groups with concat(group, suffix).
•
−−drop−source
Drop source table after all rows have been moved.
•
−−error−insert
Insert random temporary errors (testing option).
•
−−exclude−missing−columns
Ignore extra columns in source or target table.
•
−−help
Display help text and exit.
•
−−login−path
Read given path from login file.
•
−−lossy−conversions,
−l
Allow attribute data to be truncated when converted to a
smaller type.
•
−−ndb−connectstring
Set connect string for connecting to ndb_mgmd. Syntax:
"[nodeid=id;][host=]hostname[:port]". Overrides
entries in NDB_CONNECTSTRING and my.cnf.
•
−−ndb−mgmd−host
Same as −−ndb−connectstring.
•
−−ndb−nodeid
Set node ID for this node, overriding any ID set by
−−ndb−connectstring.
•
−−ndb−optimized−node−selection
Enable optimizations for selection of nodes for
transactions. Enabled by default; use
−−skip−ndb−optimized−node−selection
to disable.
•
−−no−defaults
Do not read default options from any option file other than
login file.
•
−−print−defaults
Print program argument list and exit.
•
−−promote−attributes,
−A
Allow attribute data to be converted to a larger type.
•
−−staging−tries=x[,y[,z]]
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).
•
−−usage
Display help text and exit; same as
−−help.
•
−−verbose
Enable verbose messages.
•
−−version
Display version information and exit.
Copyright © 1997, 2023, Oracle and/or its affiliates.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/.
Oracle Corporation (http://dev.mysql.com/).