5.5

Table Of Contents
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 53. 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.
Chapter 5 Cell Management Tool Reference
VMware, Inc. 51