ndb_select_all
— Print Rows from an NDB Table
1642
Note
If a table has no explicit primary key, then the output generated when using the
--print_data
[1640]
option includes the table's hidden primary key.
--verbose=#
Sets the level for the verbosity of the output. The minimum is 0; the maximum is 255. The default value
is 1.
Beginning with MySQL 5.0.40, it is possible to restore selected databases, or to restore selected tables
from a given database using the syntax shown here:
ndb_restore
other_options
db_name
,[
db_name
[,...] |
tbl_name
[,
tbl_name
][,...]]
In other words, you can specify either of the following to be restored:
• All tables from one or more databases
• One or more tables from a single database
Error reporting.
ndb_restore
reports both temporary and permanent errors. In the case of temporary errors, it may
able to recover from them. Beginning with MySQL 5.0.29, it reports
Restore successful, but
encountered temporary error, please look at configuration
in such cases.
17.4.15.
ndb_select_all
— Print Rows from an NDB Table
ndb_select_all
prints all rows from an
NDB
table to
stdout
.
Usage
ndb_select_all -c
connect_string
tbl_name
-d
db_name
[>
file_name
]
The following table includes options that are specific to the MySQL Cluster native backup restoration
program
ndb_select_all
. Additional descriptions follow the table. For options common to most
MySQL Cluster programs (including
ndb_select_all
), see
Section 17.4.20, “Options Common to
MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
.
Table 17.20.
ndb_select_all
Options and Variables: MySQL 5.0
Format
Description
Added / Removed
--database=dbname [1643]
,
-d [1643]
Name of the database in which the
table is found
All MySQL 5.0
based releases
--parallelism=# [1643]
,
-p [1643]
Degree of parallelism
All MySQL 5.0
based releases
--lock=# [1643]
,
-l [1643]
Lock type
All MySQL 5.0
based releases
--order=index [1643]
,
-o [1643]
Sort resultset according to index
whose name is supplied
All MySQL 5.0
based releases
--descending [1643]
,
-z [1643]
Sort resultset in descending order
(requires order flag)
All MySQL 5.0
based releases
--header [1643]
,
Print header (set to 0|FALSE to
disable headers in output)
All MySQL 5.0
based releases
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...