Fairbanks FB3000 Highway System Application User Manual

Page 48

Section 3: Highway System Mode of Operation

7/08

51188 Rev. 1

3.5.23.8. Data Collection & Reporting:

Maintenance / Utilities,

Continued

BUTTON

FUNCTION

Analyzes and stores the key distribution for the table(s.

Backs up the table(s) to a selected folder.

Checks the table(s) for errors.

Changed –

Only check tables which have been changed

since last check, or have not been properly closed.

Extended –

Do a full key lookup for all keys for each row.

This ensures that the table is 100% consistent.

• This process takes longer to complete.

Fast –

Only checks tables which have not been properly

closed.

Medium –

Scan rows to verify that deleted links are okay.

This also calculates a key checksum for the rows and
verifies this with a calculated checksum for the keys.

Quick – Doesn’t scan the rows to check for

wrong links.

Used to deleted a large part of the table(s), or to make many
changes to a table with variable-length rows.

Repairs a possibly corrupted table.

Extended –

MySQL creates the index row-by-row, instead of

creating one index at a time with sorting.
This may be better than using the sorting function on
fixed-length keys, especially on long

CHAR keys

that

compress very well.

Quick –

MySQL

tries to repair only the index tree

Restores the table(s) from the backup that was previously made
with

Backup

Generates the

SQL script

for the Highway Database.

Structure –

Generates a SQL script containing the DB

structure only.

Data –

Generates a SQL script containing the data only.

All –

Generates a SQL script containing both structure and

data.

In a networked environment, the user will encounter a series of
prompts allowing the local database to be replicated.

Note:

This deletes all data on the selected remote FB3000 and

replaces it with a copy of this unit’s database.

The

Search Button

expands/limits the activity displayed in the

SQL Monitor

(the memo field at the bottom of the page).