Foxhound 5.0 FAQ
search engine by freefind advanced
Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad           Breck.Carter@gmail.com     


Question: How do I move the Foxhound database to a different location?

Answer:

Some customers require that software may be installed on the C: drive, for example, but updatable files (e.g., the Foxhound database) must be installed in a different location.

Here is an example that shows how the Foxhound database may be moved from the original installation folder

C:\ProgramData\RisingRoad\Foxhound5

to a different drive

H:\ProgramData\RisingRoad\Foxhound5
  1. Shut down Foxhound if it is running.

  2. Create the destination folder; e.g., H:\ProgramData\RisingRoad\Foxhound5

  3. Move these files from the original installation folder to the new destination:
    foxhound5.db
    foxhound5.log
    rroad5_sa17_bin32.dll
    rroad5_sa17_bin64.dll
    

  4. Create the destination "setup" subfolder; e.g., H:\ProgramData\RisingRoad\Foxhound5\setup

  5. Copy these files from the original "setup" subfolder to the destination "setup" subfolder:
    $$BUILD_NUMBER.txt
    foxhound5.db.5.0.*.ORIGINAL_COPY
    

  6. If it exists, move this subfolder:
    C:\ProgramData\RisingRoad\Foxhound5\backup
    

    to the new destination:

    H:\ProgramData\RisingRoad\Foxhound5\backup
    

  7.   Add or change the code shown in yellow  in these command files:

    C:\ProgramData\RisingRoad\Foxhound5\     $backup_foxhound5.bat

    ECHO OFF
    ECHO Foxhound5 - 3 Backup Database
    REM Optional parameters DBFOLDER SERVER
    CD /D H:\ProgramData\RisingRoad\Foxhound5
    SETLOCAL ENABLEDELAYEDEXPANSION
    SETLOCAL ENABLEEXTENSIONS
    ...
    

    C:\ProgramData\RisingRoad\Foxhound5\     $mini_restore_foxhound5.bat

    ECHO OFF
    ECHO Foxhound5 - 9 Mini-Restore
    REM Optional parameters DBFOLDER SERVER
    CD /D H:\ProgramData\RisingRoad\Foxhound5
    SETLOCAL ENABLEDELAYEDEXPANSION
    SETLOCAL ENABLEEXTENSIONS
    

    C:\ProgramData\RisingRoad\Foxhound5\     $start_foxhound5_default_browser.bat

    ECHO OFF
    ECHO Foxhound5 - 1 Start Foxhound
    REM Optional parameters DBFOLDER SERVER
    CD /D H:\ProgramData\RisingRoad\Foxhound5
    SETLOCAL ENABLEDELAYEDEXPANSION
    SETLOCAL ENABLEEXTENSIONS
    ...
    

    C:\ProgramData\RisingRoad\Foxhound5\     $start_foxhound5_default_browser_debug.bat

    ECHO Foxhound5 - 6 Debug Start Foxhound
    REM Optional parameters DBFOLDER SERVER
    CD /D H:\ProgramData\RisingRoad\Foxhound5
    REM This "debug" version is different:
    REM - There is no ECHO OFF command,
    REM - dbstop runs before dbsrv,
    REM - the dbsrv -qn option is used, and
    REM - there is a PAUSE at the end.
    
    SETLOCAL ENABLEDELAYEDEXPANSION
    SETLOCAL ENABLEEXTENSIONS
    ...
    

    C:\ProgramData\RisingRoad\Foxhound5\     start_foxhound5_engine.bat

    ECHO OFF
    ECHO Foxhound5 - 7 Start Foxhound Engine
    REM Optional parameters DBFOLDER SERVER
    CD /D H:\ProgramData\RisingRoad\Foxhound5
    SETLOCAL ENABLEDELAYEDEXPANSION
    SETLOCAL ENABLEEXTENSIONS
    ...
    

    C:\ProgramData\RisingRoad\Foxhound5\scripts\     $create_SQL_Anywhere_17_bin64_service.bat

    ...
    ECHO To create the Foxhound5 service...
    PAUSE
    "C:\Program Files\SQL Anywhere 17\Bin64\dbsvc.exe"^
      -o "C:\ProgramData\RisingRoad\Foxhound5\dbsvc_log.txt"^
      -y^
      -as^
      -s Automatic^
      -sn Foxhound5^
      -sd "Foxhound Version 5 Database Monitor Bin64 Service"^
      -t Network^
      -w Foxhound5 "C:\Program Files\SQL Anywhere 17\Bin64\dbsrv17.exe"^
      -c 25p^
      -ch 50p^
      -cr-^
      -gk all^
      -gl all^
      -gn 220^
      -gna 0^
      -m^
      -n foxhound5^
      -o "C:\ProgramData\RisingRoad\Foxhound5\foxhound5_debug.txt"^
      -oe "C:\ProgramData\RisingRoad\Foxhound5\foxhound5_debug_startup.txt"^
      -on 1M^
      -qn^
      -sb 0^
      -ufd restart^
      -x tcpip^
      -xd^
      -xs http(port=80;maxsize=0;to=600;kto=600)^
      "H:\ProgramData\RisingRoad\Foxhound5\foxhound5.db"^
      -n f
    ...
    

    C:\ProgramData\RisingRoad\Foxhound5\scripts\     $run_most_recent_mini_restore.bat

    ECHO OFF
    ECHO Foxhound5 - Run Most Recent Mini-Restore
    CD /D H:\ProgramData\RisingRoad\Foxhound5
    SETLOCAL ENABLEDELAYEDEXPANSION
    SETLOCAL ENABLEEXTENSIONS
    ...
    
  8. Now you can start Foxhound again.

See also...
How do I move Foxhound to a different disk drive?
How do I move the Foxhound transaction log to a different physical disk drive?


This page was last updated on February 13, 2020.      Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com