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.
Three files are created: <table>.Agz, <table>.num, and <table>.seq.
<table>.Agz. This is 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 this is checked against the number of records loaded to ensure integrity.
<table>.seq is the next sequence number to be allocated. When recovering a table this is used to set the next sequence number.
Any extra arguments are assumed to be 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. |