View source for Verifying Database Integrity

The Recital database integrity verification tool, [[recitalintegrity|recitalintegrity]],  is used to check for, and if required correct, errors found in Recital tables, indexes and memo files.

===Using the recitalintegity Command to Verify Data===
The recitalintegity command can operate on an individual table, a database, a directory or a directory structure.  The options below are used to specify the target data, configure the output displayed and control the correction of errors.

{| class="wikitable"
!Options||Description
|-
|&#045;f &#060;table&#062;||table to verify
|-
|&#045;d &#060;directory&#062;||directory to verify
|-
|&#045;D &#060;database&#062;||database to verify
|-
|&#045;r||recursively process subdirectories
|-
|&#045;y||repair data if errors are found
|-
|&#045;q||only display errors
|-
|&#045;a||verbose mode
|-
|&#045;&#045;help, -h||display the usage information
|-
|}

<pre>
# recitalintegrity -D southwind -a
</pre>

===Correcting Corrupted Data===
The '''-y''' flag is used to signal that any errors found should be corrected.

<pre>
# recitalintegrity -D southwind -a -y
</pre>