Difference between revisions of "Verifying Database Integrity"

From Recital Documentation Wiki
Jump to: navigation, search
(Using the dbintegity Command to Verify Data)
 
(4 intermediate revisions by one user not shown)
Line 1: Line 1:
==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===
 
===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
 +
|-
 +
|-f <table>||table to verify
 +
|-
 +
|-d <directory>||directory to verify
 +
|-
 +
|-D <database>||database to verify
 +
|-
 +
|-r||recursively process subdirectories
 +
|-
 +
|-y||repair data if errors are found
 +
|-
 +
|-q||only display errors
 +
|-
 +
|-a||verbose mode
 +
|-
 +
|--help, -h||display the usage information
 +
|-
 +
|}
 +
 +
 +
<pre>
 +
# recitalintegrity -D southwind -a
 +
</pre>
  
 
===Correcting Corrupted Data===
 
===Correcting Corrupted Data===
===Summary===
+
The '''-y''' flag is used to signal that any errors found should be corrected.
 +
 
 +
<pre>
 +
# recitalintegrity -D southwind -a -y
 +
</pre>

Latest revision as of 12:06, 15 March 2010

The Recital database integrity verification tool, 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.

Options Description
-f <table> table to verify
-d <directory> directory to verify
-D <database> database to verify
-r recursively process subdirectories
-y repair data if errors are found
-q only display errors
-a verbose mode
--help, -h display the usage information


# recitalintegrity -D southwind -a

Correcting Corrupted Data

The -y flag is used to signal that any errors found should be corrected.

# recitalintegrity -D southwind -a -y