Subject | Re: Restoring database > 4 GB |
---|---|
Author | Aage Johansen |
Post date | 2003-05-03T11:47:44Z |
jeffshoaf wrote:
summer).
I never was able to complete that restore. Other backup files (made the
same way) were fine, however.
It was a small database - about 50MB.
Later:
I think I found a copy of the backup that couldn't be restored, and I am
looking at the contents - it is from June 2002. The first 1/3 of the file
seems fine, but after that there is only zeroes.
A hex dump of the backup looks like:
007EFF50 11 04 20 00 00 00 02 04 00 00 4F 51 FD 00 06 05 .. .......OQý...
007EFF60 42 41 4D 53 45 FA 00 01 0D F4 00 06 01 04 20 00 BAMSEú...ô.... .
007EFF70 00 00 11 04 1C 00 00 00 02 04 00 00 4F 51 FD 00 ............OQý.
007EFF80 05 04 48 41 4E 4E FD 00 01 0D F4 00 06 01 04 1C ..HANNý...ô.....
007EFF90 00 00 00 11 04 20 00 00 00 02 04 00 00 4F 51 FD ..... .......OQý
007EFFA0 00 09 08 46 2E 31 33 30 37 30 30 FD 00 01 0D F4 ...F.130700ý...ô
007EFFB0 00 06 01 04 20 00 00 00 11 04 20 00 00 00 02 04 .... ..... .....
007EFFC0 00 00 4F 51 FD 00 06 05 59 52 56 49 4E FA 00 01 ..OQý...YRVINú..
007EFFD0 0D F4 00 06 01 04 20 00 00 00 11 04 1C 00 00 00 .ô.... .........
007EFFE0 02 04 00 00 4F 51 FD 00 03 02 46 2E FB 00 01 0D ....OQý...F.û...
007EFFF0 F4 00 06 01 04 1C 00 00 00 11 04 20 00 00 00 02 ô.......... ....
007F0000 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
007F0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
and so on ...
I guess this is from this table
CREATE TABLE XVETBASE (
VERDI VARCHAR( 16 ) NOT NULL primary key,
FELT SMALLINT NOT NULL,
ID INTEGER NOT NULL,
CONSTRAINT INTEG_26 PRIMARY KEY ( VERDI, FELT, ID)
)
--
Aage J.
> Done with volume #1, "labels.gbk"I've seen this (don't remember which version of Fb, but I think it was last
> Press return to reopen that file, or type a new
> name followed by return to open a different file.
summer).
I never was able to complete that restore. Other backup files (made the
same way) were fine, however.
It was a small database - about 50MB.
Later:
I think I found a copy of the backup that couldn't be restored, and I am
looking at the contents - it is from June 2002. The first 1/3 of the file
seems fine, but after that there is only zeroes.
A hex dump of the backup looks like:
007EFF50 11 04 20 00 00 00 02 04 00 00 4F 51 FD 00 06 05 .. .......OQý...
007EFF60 42 41 4D 53 45 FA 00 01 0D F4 00 06 01 04 20 00 BAMSEú...ô.... .
007EFF70 00 00 11 04 1C 00 00 00 02 04 00 00 4F 51 FD 00 ............OQý.
007EFF80 05 04 48 41 4E 4E FD 00 01 0D F4 00 06 01 04 1C ..HANNý...ô.....
007EFF90 00 00 00 11 04 20 00 00 00 02 04 00 00 4F 51 FD ..... .......OQý
007EFFA0 00 09 08 46 2E 31 33 30 37 30 30 FD 00 01 0D F4 ...F.130700ý...ô
007EFFB0 00 06 01 04 20 00 00 00 11 04 20 00 00 00 02 04 .... ..... .....
007EFFC0 00 00 4F 51 FD 00 06 05 59 52 56 49 4E FA 00 01 ..OQý...YRVINú..
007EFFD0 0D F4 00 06 01 04 20 00 00 00 11 04 1C 00 00 00 .ô.... .........
007EFFE0 02 04 00 00 4F 51 FD 00 03 02 46 2E FB 00 01 0D ....OQý...F.û...
007EFFF0 F4 00 06 01 04 1C 00 00 00 11 04 20 00 00 00 02 ô.......... ....
007F0000 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
007F0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
and so on ...
I guess this is from this table
CREATE TABLE XVETBASE (
VERDI VARCHAR( 16 ) NOT NULL primary key,
FELT SMALLINT NOT NULL,
ID INTEGER NOT NULL,
CONSTRAINT INTEG_26 PRIMARY KEY ( VERDI, FELT, ID)
)
--
Aage J.