LexBuild

LexBuild - Backup & Restore

Several data base interface scripts and programs are provided for routine backup and restore. The program, options, and inputs, outputs are described as follows: EXBUILD/Tools/LoadDb

  • Program:
    $LEXBUILD_DIR/Tools/LoadDb/DbScript

  • Inputs:
    Files from $LEXBUILD/data/DbTables/Tables
    • comments.bak
    • inflVars.bak
    • lexicon.bak
    • newTerms.bak
    • eui.bak
    • inflVarsTemp.bak
    • lexiconTemp.bak
    • user.bak

  • Options
    --------------------------------------
    Which Program ?
    --------------------------------------
    1) Create tables
    2) Check tables
    3) Load tables
    4) Get table row number
    5) Backup tables
    6) Delete tables
    7) Drop tables
    
    --------------------------------------
    Which Table(s) ?
    --------------------------------------
    1) USER
    2) EUI
    3) LEX_RECORD
    4) LEX_RECORD_TEMP
    5) INFL_VARS
    6) INFL_VARS_TEMP
    7) NEW_TERMS
    8) LEX_RECORD_COMMENTS
    9) All but USER
    10) All but EUI
    11) All (default)
    
    --------------------------------------
    Which Database ?
    --------------------------------------
    1) lexBuild (default)
    2) lexBuild2 (backup & test)
    ----------
    
  • Outputs
    • Most programs generate status report on the standard outputs (screen)
    • Backup program generates flat files for all Db tables under ${BACKUP_DIR}/Routine/LexBuild/${YEAR}/mm_dd_yy/