At 12:22 PM 21/06/2005 +0800, you wrote:

>On 6/21/05, Nigel Weeks <nweeks@...> wrote:
> > Hmm. How big does the file get before it stops? 2GB-ish?
>
>Can't tell.. the ftp cli stops with only those error
>
>On 6/21/05, Helen Borrie <helebor@...> wrote:
> > If you don't have any NTFS 5 partitions available, you can take a fresh
> > backup on your Linux (presumably ext3) system, backing up to multiple
> > files. Similarly, when you restore on the FAT partition, you can restore
> > the database as multiple files of suitable sizes. Once your backups and
> > database files are split into multiple files, make sure you keep them
> > together when you move backups and databases around.
>
>Helen,
>So I need to restore the fbk and back it up again into smaller files ?

No, re-run the (transportable) backup but have gbak back up the Linux
database to multiple fbk files.

>Can I just split the fbk using split command

I don't know what you mean by "split command". There was a command-line
utility called gsplit in older versions of InterBase that was superseded by
enhancing the capabilities of gbak to split and merge backup and database
files integrally with the backup or restore operation. Gsplit doesn't work
with Firebird.

If you don't have The Firebird Book, you can study the IB 6 beta
OpGuide.pdf, which tells you how to make multi-file backups and how to
restore from single or multi-file backups to multiple database files.

>and just restore back at the windows machine?

Restore onto the Windows machine, into multiple files, each of which is
limited to be slightly smaller than the filesystem limit. You will almost
certainly need considerably more database files than backup files. Make
sure you know which filesystem you are preparing for, since that affects
the size limit - use the property sheets of the partitions to find out.

>Will the db work?

Of course, as long as you do it properly. It's not very long since
effectively all but very small databases had to be multi-file.

./hb