NAME
ubTableDump – dump one or more tables for archiving
SYNOPSIS
ubTableDump {--csv} {--dir <destination directory>} {<tables>}DESCRIPTION
ubTableDump will dump the contents of one or more application tables so that they can be reliably reloaded.
The system creates three files: <table>.Agz, <table>.num, and <table>.seq.
<table>.Agz. This function returns an A format dump of the table that is gzipped.
A format means each record is dumped as lines of <field>,<value> if the field is not empty followed by a line with just > to indicate the end of record.
<table>.num is the number of records dumped. When recovering a table using ubTableLoad, the system checks this value against the number of records loaded to ensure integrity.
<table>.seq is the next sequence number to be allocated. When recovering a table, the system uses this value to set the next sequence number.
The command assumes any extra arguments are tables to be dumped rather than all the application tables.
FLAGS
| FLAG | ARGUMENT | TYPE | DESCRIPTION |
|---|---|---|---|
| –csv | The output of ubTableDump will be in csv format. ie the first line will be field names and each subsequent line will be a record in valid csv format. | ||
| –dir | destination directory | string | The name of a directory for the dumped table files. |
