miércoles, agosto 31, 2005

USO DE GBAK (INTERBASE / FIREBIRD)

# para backupear una base de datos interbase.
# -B(ACKUP_DATABASE) backup database to file
# -T(RANSPORTABLE) transportable backup -- data in XDR format
# -V(ERIFY) report each action taken
# -Z print version number
# -Y redirect/suppress status message output
# -C(REATE_DATABASE) create database from backup file
# -R(EPLACE_DATABASE) replace database from backup file



# Ejemplos:

# Hacer BK
rm /tmp/backup.log; gbak -b -t -v -user SYSDBA -pas xxx-y /tmp/backup.log localhost:/opt/interbase/data/tape-rk.gdb /tmp/tape-rk.gbk
gbak -b -t -v -user SYSDBA -pas xxx-y /tmp/backup.log localhost:/opt/interbase/data/tape116-5.gdb

/tmp/tape-backup-116-5.gbk

#verificar
cat /tmp/backup.log


# Restaurar BK
gbak -r -c -v -z -user SYSDBA -pas xxx -y /tmp/restore-preparar-lapatria.log /tmp/tape-backup-preparar-lapatria.gbk

localhost:/opt/interbase/data/tape114-1.gdb

#para reemplazar bd
gbak -r -c -v -z -user SYSDBA -pas xxxx -y /tmp/restore-116-5.log /tmp/tape-backup-116-5.gbk

localhost:/opt/interbase/data/tape-desarrollo.gdb

#para crear bd
rm /tmp/restore-116-5.log;
gbak -c -v -z -user SYSDBA -pas xxxx -y /tmp/restore-116-5.log /tmp/tape-rk.gbk localhost:/opt/interbase/data/tape-desarrollo.gdb

gbak -r -c -v -z -user SYSDBA -pas xxx -y /tmp/restaurar-toluca.log toluca.gbk

localhost:/opt/interbase/data/TOLUCA.TRAIDO.GDB

gbak -c -v toluca.gbk weallgodown.gdb

Additionally, there is a command-line tool gsplit that filters the
output of gbak and writes to multiple files on disk. This permits you
to back up a multifile database when the backup file is larger than
the operating system maximum.

Etiquetas: , ,