Database administration [Документация VAS Experts]

This is an old revision of the document!


2 Database administration

The built-in database is fault-tolerant and does not require administration. However, it has occurred in some rare cases that database has been corrupted. In this case, the following options are possible:

  1. database deletion and subsequent loading of data from scratch
    Stop dpi
    service fastdpi stop
    Delete database
    /bin/rm /var/db/dpi/*
    Launch dpi
    service fastdpi start
    Load all settings in the database from scratch 
  2. database recovery with data transfer
    Stop dpi
    service fastdpi stop
    Run script
    mdb_dump -a -f dump.txt /var/db/dpi
    /bin/rm /var/db/dpi/*
    mdb_load -f dump.txt /var/db/dpi
    Launch dpi
    service fastdpi start