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/