Firebird gbak backing up a remote database that has spaces in the path and is on a remote Windows machine
Posted by jpluimers on 2016/09/13
I will likely need a batch file like this again:
setlocal set gbakExe=C:\Program Files (x86)\Firebird\Firebird_2_5\bin\gbak.exe set dbPart=MyDatabase set dbSource=192.168.199.24:C:\Path with spaces\%dbPart%.fdb set dbUser=sysdba set dbPassword=masterkey "%gbakExe%" -verify -transportable -user %dbUser% -password %dbPassword% "%dbSource%" %dbPart%.fbk endlocal
You need the quotes around %gbakExe% and %dbSource% to ensure spaces in paths are preserved.
–jeroen
Sources:
- gbak Command-line Options
- How to backup the remote database to a local hard disk?
- Remote Backup & Restore Recipes
- gbak Backup Mode
- Firebird remote backup – Stack Overflow
Leave a Reply