1) I often copy .gdb from Linux server to Windows XP and backup/restore then
copy back the .gdb to linux server, it seems running fine, any side effect
of that?
2) When .gdb size is bigger than 1G, backup usually takes time, what is the
good approach to backup? using a cron job in linux and run the gbak while
.gdb is being accessed by other programs? advisable?
Thanks,
Frank
You run the risk of corrupting the database and the copy if people are
accessing it at the same time. Don't copy the database if you can back it
up instead.
> 2) When .gdb size is bigger than 1G, backup usually takes time, what is
> the good approach to backup? using a cron job in linux and run the gbak
> while .gdb is being accessed by other programs? advisable?
The Interbase backup routines are designed to run against an active database
(hot backups). There are some settings, such as disabling garbage
collection, that can speed up the backup time.
Dan
> 1) I often copy .gdb from Linux server to Windows XP and
> backup/restore then copy back the .gdb to linux server, it seems
> running fine, any side effect of that?
That is not supported. If you think that doing things that are
unsupported and untested may have side effects then don't do it. :)
>
> 2) When .gdb size is bigger than 1G, backup usually takes time, what
> is the good approach to backup? using a cron job in linux and run the
> gbak while .gdb is being accessed by other programs? advisable?
The first thing to try to improve backup performance is to use the -g
switch on gbak to disable garbage collection. Run a sweep during off
hours to remove garbage records.
--
Bill Todd (TeamB)
Thanks for your quick response. I know this is not supported. was fixing a
.gdb, can't do backup/restore in the linux server, and i made sure nobody
was connected, then copied the .gdb to winXP, do a gfix/backup/restore,
checked the .gdb in Windows, everything seems fine, then copied back to
Linux, it runs.
Thanks, is there any big time difference between a gdb in use and and a gdb
not accessed at time of backup? can we backup .gdb into a mounted USB drive?
--
Bill Todd (TeamB)
I don't think you can do a remote backup via IBConsole. You can using GBAK,
though.
Dan
Performing the backup will put some load on the server, so users may be
affected. You can certainly kick everyone out, then do the backup, but it's
not required.
You can back up directly to a USB drive as long as there's enough space.
Dan
> I don't think you can do a remote backup via IBConsole. You can
> using GBAK, though.
The backup does not need to be remote. He could backup to the local
drive in transportable format, copy the backup to the Windows machine
and restore it. The point is that there are a lot of safe ways to get
the database from the Linux box to the Windows box. He does not have to
copy the GDB file across platforms.
--
Bill Todd (TeamB)
Hi Bill,
Actually the problem is this IB 6.X (super server) something that i
downloaded from http://mers.com, after upgrading, i can't run any more GBAK,
GFIX in the server and I don't know how to remove it from the server and go
back to the original IB6.0. finally i used those services APIs to
mend/backup/restore, it seems working, thanks.
Frank
I have no idea why you cannot run gbak on your Linux system since you
have not provided any detailed information about the problem.
--
Bill Todd (TeamB)