. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2. Command Line Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . system administrator to set file system permissions which prevent execution of certain programs and utilities for security reasons. The Firebird database holds details of all users in a single security database SYSDBA username and password and/or are logged in as a privileged user. Like most of the command line utilities supplied with Firebird, gsec can be run in interactive or batch mode and has a help screen

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 4. Command Line Switches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . text-mode client tool located in the bin directory of the Firebird installation. It provides a command line interface for interactive access to a Firebird database. It accepts DSQL statements along with commands. The isql utility can be used in three modes: as an interactive session; directly from the command line; and as a non-interactive session, using a shell script or batch file. Different tasks may be

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2. Command-line Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Table of Contents 1 Chapter 1. Introduction Gbak is one of the database backup and restore utilities supplied with Firebird. In Firebird 1.5 it is the only supplied utility of this kind while Firebird nbackup utility which is described in another document. In this manual, we will discuss: • Command-line options for gbak. • gbak commands and their parameters. • Running gbak in backup or restore

.......................................................................................... 8 Command-line Tools ....................................................................................... root directory of a v.1.5.x installation, there will be situations where the Firebird engine, command-line tools, cron scripts, batch files, installers, etc., will not work as expected. If the Windows Compatibility Issues 2 visible in the workspace where you are installing Firebird--use the SET FIREBIRD command in a Windows shell or printenv FIREBIRD in a POSIX shell. Security in Firebird 2 (All Platforms)

the Firebird server: • The Firebird server executable. • One or more client libraries. • The command-line tools. • The standard user-defined function libraries. • A sample database. • The C header files files /doc Firebird server fbserver (SS) or fb_inet_ server (CS) /bin Command-line tools isql, gbak, nbackup, gsec, gfix, gstat, etc. /bin Sample database employee \doc Firebird server fbserver.exe (SS) or fb_in- et_server.exe (CS) \bin Command-line tools isql.exe, gbak.exe, nback- up.exe, gsec.exe, gfix.exe, gstat.exe, etc. \bin

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2. Command Line Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . changes to their databases. Almost all the gfix commands have the same format when typed on the command line: gfix [commands and parameters] database_name The commands and their options are described in data file added. Coming up in the remainder of this manual, we will discuss the following: • Command line options for the gfix database utility. • Shadow file handling. • Cache and buffer handling.

server: • The Firebird server executable. • A client library located on the server machine. • The command-line tools. • The standard user-defined function libraries. • A sample database. • The C header ) C:\Program Files\Firebird Firebird server ibserver.exe (SS only) \bin Command-line tools gbak.exe, gfix.exe, gstat.exe, etc. \bin Sample database employee.gdb \ex- ) /opt/interbase Firebird server ibserver (SS) or gds_inet_server (CS) /bin Command-line tools gbak, gfix, gstat, etc. /bin Sample database employee.gdb /ex-

client/server connections. Chapter 3. Installing Firebird 9 3.4.1. Pinging the server The ping command — available on most systems — is a quick and easy way to see if you can connect to a server machine address in the domain that is visible to your client is 192.13.14.1, go to a command shell on the client machine and type the command ping 192.13.14.1 substituting this example IP address with the IP address how to test the server on each platform. Server check: Linux and other Unices Use the top command in a command shell to inspect the running processes interactively. If a Firebird 5 server is running,

. 2 2. Gsplit Command line Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 3. Gsplit Command Parameters. . . files to be 4 Gb. Coming up in the remainder of this manual, we will discuss the following: • Command line options for gsplit. • Gsplit options and their parameters. • Splitting backups using gsplit the Linux version. Linux doesn’t require a separate utility as it can split files using the split command as well as using gbak.  In testing with Firebird 1.5 and Firebird 2.0 on Windows XP Home and WIndows

areas addressed in this volume. This document does not cover configuration of Firebird, Firebird command-line tools, nor its programming APIs. 1.2. Authorship For the Firebird 4.0 version, the Firebird in ESQL. Interactive ISQL refers to the language that can be executed using Firebird isql, the command-line application for accessing databases interactively. As a regular client application, its native characters, alone or in combinations, may be used as operators (arithmetical, string, logical), as SQL command separators, to quote identifiers and to mark the limits of string literals or comments. Operator