Thread View: borland.public.interbase.opensource
11 messages
11 total messages
Started by FrankW
Wed, 15 Feb 2006 12:35
Some GDB questions
Author: FrankW
Date: Wed, 15 Feb 2006 12:35
Date: Wed, 15 Feb 2006 12:35
13 lines
1334 bytes
1334 bytes
Hi, 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
Re: Some GDB questions
Author: Bill Todd
Date: Tue, 14 Feb 2006 20:51
Date: Tue, 14 Feb 2006 20:51
19 lines
1767 bytes
1767 bytes
FrankW wrote: > 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)
Re: Some GDB questions
Author: Dan Palley
Date: Tue, 14 Feb 2006 21:29
Date: Tue, 14 Feb 2006 21:29
21 lines
1738 bytes
1738 bytes
"FrankW" <nospam@nospam.com> wrote in message news:43f2403b@newsgroups.borland.com... > Hi, > > 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? 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
Re: Some GDB questions
Author: Bill Todd
Date: Tue, 14 Feb 2006 22:06
Date: Tue, 14 Feb 2006 22:06
6 lines
1265 bytes
1265 bytes
Why not connect to the IB server on the Linux box from a Windows machine and run the backup from the Windows machine using gbak or IBConsole? -- Bill Todd (TeamB)
Re: Some GDB questions
Author: Bill Todd
Date: Tue, 14 Feb 2006 23:37
Date: Tue, 14 Feb 2006 23:37
13 lines
1553 bytes
1553 bytes
Dan Palley wrote: > 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)
Re: Some GDB questions
Author: Dan Palley
Date: Wed, 15 Feb 2006 00:18
Date: Wed, 15 Feb 2006 00:18
15 lines
1537 bytes
1537 bytes
"FrankW" <nospam@nospam.com> wrote in message news:43f25b44@newsgroups.borland.com... > Hi Dan, > > 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? 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
Re: Some GDB questions
Author: Dan Palley
Date: Wed, 15 Feb 2006 00:18
Date: Wed, 15 Feb 2006 00:18
10 lines
1462 bytes
1462 bytes
"Bill Todd" <no@no.com> wrote in message news:43f2628a$1@newsgroups.borland.com... > Why not connect to the IB server on the Linux box from a Windows > machine and run the backup from the Windows machine using gbak or > IBConsole? I don't think you can do a remote backup via IBConsole. You can using GBAK, though. Dan
Re: Some GDB questions
Author: Bill Todd
Date: Wed, 15 Feb 2006 13:47
Date: Wed, 15 Feb 2006 13:47
10 lines
1617 bytes
1617 bytes
If by "the original IB 6.0" you mean version 6.0.1.0 of the open source version of IB, you do not want to go there. 6.0.1.0 is a pre-release version that has a bug that can corrupt your database. Use either 6.0.1.6 or 6.0.2.0 from http://mers.com . 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)
Re: Some GDB questions
Author: FrankW
Date: Wed, 15 Feb 2006 14:08
Date: Wed, 15 Feb 2006 14:08
17 lines
1638 bytes
1638 bytes
"Bill Todd" <no@no.com> wrote in message news:43f250d6$1@newsgroups.borland.com... > FrankW wrote: > >> 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. :) 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.
Re: Some GDB questions
Author: FrankW
Date: Wed, 15 Feb 2006 14:30
Date: Wed, 15 Feb 2006 14:30
11 lines
1384 bytes
1384 bytes
Hi Dan, 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? > > 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 >
Re: Some GDB questions
Author: FrankW
Date: Wed, 15 Feb 2006 19:20
Date: Wed, 15 Feb 2006 19:20
17 lines
1640 bytes
1640 bytes
"Bill Todd" <no@no.com> wrote in message news:43f277b1$1@newsgroups.borland.com... > Dan Palley wrote: > > the database from the Linux box to the Windows box. He does not have to > copy the GDB file across platforms. 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
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads