How to Backup and Restore VectorWise DB

    Windows:

    Backup:

    1. Stop the NetFlow Analyzer service.
    2. Open a command prompt as 'Administrator' and navigate to OpManager\bin (or) NetFlow\bin.Execute VWstartdb.bat (This step can be ignored, if you get the message "Vectorwise is already running. Use ingstop to shut down Vectorwise".)
    3. Create a new folder to which the backup has to be saved (Eg. C:\NFA backup).
    4. In command prompt, navigate to C:\NFA backup.
    5. Execute copydb OpManagerDB (or) copydb netflow. This command will create two script files named copy.in and copy.out
    6. Execute sql OpManagerDB < copy.out (or) sql netflow < copy.out. This will start copying the database. Please wait and continue with the restoration process.
    7. Navigate to OpManager\bin (or) NetFlow\bin. Execute VWstopdb.bat
    8. Once complete, copy the backup folder (C:\NFA backup) to New server. 

      Note: The directory structure for the backup folder should be the same as in the new server (C:\NFA backup).

    Restore:

    Once the folder is copied to the new server follow the below steps to restore.

    Note: The directory structure of the backup folder should be the same as in the old server (C:\NFA backup).

    1. Stop the Netflow Analyzer service.
    2. Open a command prompt as 'Administrator' and navigate to OpManager\bin (or) NetFlow\bin. Execute VWstartdb.bat
    3. If HighPerf is installed on NetFlow Analyzer server, execute VWcreatedb.bat. Users can skip this step if HighPerf is installed on a remote server.
    4. In command prompt, navigate to C:\NFA backup.
    5. Execute sql OpManagerDB < copy.in (or) sql netflow < copy.in
    6. Start the NetFlow Analyzer service.

    Linux:

    Backup:

    1. Stop the NetFlow Analyzer service.
    2. Open a terminal and login as 'installation owner'.
    3. Navigate to OpManager/bin (or) NetFlow/bin. Execute
      • . ./VWenv.sh
      • ./VWstartdb.sh  
      Note: This step can be ignored, if you get the message - "Vectorwise is already running. Use ingstop  to shut down Vectorwise".
    4. Create a new folder to which the backup has to be saved ( Eg. /tmp/NFAHighPerfBackup/ ).
    5. In the same terminal, navigate to /tmp/NFAHighPerfBackup/
    6. Execute copydb OpManagerDB (or) copydb netflow. The above command will create two script files named copy.in and copy.out
    7. Execute sql OpManagerDB < copy.out (or) sql netflow < copy.out. This will start copying the database. Please wait and continue with the restoration process.
    8. Once complete, copy the backup folder ( /tmp/NFAHighPerfBackup/ ) to New server.
      Note: the directory structure for the backup folder should be the same in the new server (/tmp/NFAHighPerfBackup/).
    9. Navigate to OpManager/bin (or) NetFlow/bin. Execute ./VWstopdb.sh

    Restore:

    Once the folder is copied to the new server follow the below steps to restore.

    Note: The directory structure of the backup folder should be same as in the old server (/tmp/NFAHighPerfBackup/ ) 

    1. Stop the Netflow Analyzer service.
    2. Open a terminal, and login as 'installation owner'. 
    3. Navigate to OpManager/bin (or) NetFlow/bin. Execute
      • . ./VWenv.sh
      • ./VWreinitializeDB.sh
      • ./VWstartdb.sh
    4. In the same terminal, navigate to /tmp/NFAHighPerfBackup/
    5. Execute sql OpManagerDB < copy.in (or) sql netflow < copy.in
    6. Start the NetFlow Analyzer service.