Subject | Re: nbackup+php = around-clock+around-global |
---|---|
Author | lee_domain |
Post date | 2007-09-29T10:37:45Z |
second run, on a database WITH Level 0 nbackups
Following is the Console displaying:
2007-09-29-18-01-50.
Resource id #2
SELECT RDB$BACKUP_LEVEL FROM RDB$BACKUP_HISTORY
level_0 primary nbackup found
now begin to do the nbackups
the current directory:/usr/local/apache2/htdocs
change directory to /opt/firebird/bin
the current directory:/opt/firebird/bin
./nbackup -U sysdba -P masterkey -B 1 /home/myname/employee.fdb
/tmp/bak/employee_1-2007-09-29-18-01-50.nbk
nbackup result:
now change back to starting directory
the current directory:/usr/local/apache2/htdocs
system re-check if all nbackup files in position
file name: .
file name: employee_0-2007-09-29-17-58-14.nbk
file name: employee_1-2007-09-29-18-01-50.nbk
file name: ..
nbackup file successful: /tmp/bak/employee_1-2007-09-29-18-01-50.nbk
confirm if nbackup is successful by re-connect the database
SELECT RDB$FILE_NAME FROM RDB$BACKUP_HISTORY
Resource id #2
/tmp/bak/employee_0-2007-09-29-17-58-14.nbk
/tmp/bak/employee_1-2007-09-29-18-01-50.nbk
disconnect from database OK !
Following is the Console displaying:
2007-09-29-18-01-50.
Resource id #2
SELECT RDB$BACKUP_LEVEL FROM RDB$BACKUP_HISTORY
level_0 primary nbackup found
now begin to do the nbackups
the current directory:/usr/local/apache2/htdocs
change directory to /opt/firebird/bin
the current directory:/opt/firebird/bin
./nbackup -U sysdba -P masterkey -B 1 /home/myname/employee.fdb
/tmp/bak/employee_1-2007-09-29-18-01-50.nbk
nbackup result:
now change back to starting directory
the current directory:/usr/local/apache2/htdocs
system re-check if all nbackup files in position
file name: .
file name: employee_0-2007-09-29-17-58-14.nbk
file name: employee_1-2007-09-29-18-01-50.nbk
file name: ..
nbackup file successful: /tmp/bak/employee_1-2007-09-29-18-01-50.nbk
confirm if nbackup is successful by re-connect the database
SELECT RDB$FILE_NAME FROM RDB$BACKUP_HISTORY
Resource id #2
/tmp/bak/employee_0-2007-09-29-17-58-14.nbk
/tmp/bak/employee_1-2007-09-29-18-01-50.nbk
disconnect from database OK !