|
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
-
Shut down Foxhound if it is running.
-
Create the destination folder; e.g., H:\ProgramData\RisingRoad\Foxhound5
-
Move these files from the original installation folder to the new destination:
foxhound5.db
foxhound5.log
rroad5_sa17_bin32.dll
rroad5_sa17_bin64.dll
-
Create the destination "setup" subfolder; e.g., H:\ProgramData\RisingRoad\Foxhound5\setup
-
Copy these files from the original "setup" subfolder to the destination "setup" subfolder:
$$BUILD_NUMBER.txt
foxhound5.db.5.0.*.ORIGINAL_COPY
-
If it exists, move this subfolder:
C:\ProgramData\RisingRoad\Foxhound5\backup
to the new destination:
H:\ProgramData\RisingRoad\Foxhound5\backup
-
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
...
|
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?
|