5.1

Limiting and Ordering Exported Rows
For any table, you can specify how many rows to export and how to order the exported rows. Use the -
exportSettingsFile option and create a data_export_settings.ini file that specifies individual tables. This
file is a UTF-8 file that contains zero or more entries of the following form:
[ TABLE_NAME ]
rowlimit= int
orderby= COLUMN_NAME
TABLE_NAME
The name of a table in the database. To see a list of table names, export all tables.
COLUMN_NAME
The name of a column in the specified TABLE_NAME.
This example data_export_settings.ini restricts data exported from the AUDIT_EVENT table to the first 10000
rows and orders the rows by the value in the event_time column
[AUDIT_EVENT]
rowlimit=100000
orderby=event_time
The command expects to find this file in $VCLOUD_HOME/etc/data_export_settings.ini, but you can specify
another path.
Example: Exporting All Tables From the Current vCloud Director Database.
This example exports all tables of the current vCloud Director database to the file /tmp/dbdump .
[root@cell1 /opt/vmware/vcloud-
director/bin]# ./cell-management-tool dbextract -dumpFile /tmp/dbdump
This utility outputs data from your vCloud Director system
that may contain sensitive data.
Do you want to continue and output the data (y/n)?
y
Exporting data now. Please wait for the process to finish
Exported 144 of 145 tables.
Commands for Replacing SSL Certificates
Use the certificates command of the cell management tool to replace the cell's SSL certificates.
The certificates command of the cell management tool automates the process of replacing a cell's existing
certificates with new ones stored in a JCEKS keystore. The certificates command helps you replace self-
signed certificates with signed ones. To create a JCEKS keystore containing signed certificates, see “Create and
Import a Signed SSL Certificate,” on page 17 .
To replace the cell's SSL certificates, use a command with the following form:
cell-management-tool certificates
options
Table 3-3. Cell Management Tool Options and Arguments, certificates Subcommand
Option Argument Description
--help (-h) None Provides a summary of available
commands in this category.
--config (-c) full pathname to the cell's
global.properties file
Defaults to
$VCLOUD_HOME/etc/global.prop
erties.
--responses (-r) full pathname to the cell's
responses.properties file
Defaults to
$VCLOUD_HOME/etc/responses.p
roperties.
vCloud Director Installation and Upgrade Guide
40 VMware, Inc.