Subject | Re: [firebird-support] Re: Restoring database from 2.0 to 2.5 doesn't work even if -fix_fss_data is used |
---|---|
Author | Man Gro |
Post date | 2013-03-26T22:34:45Z |
Hi guys and thank you for helping me with this.
I've already spent on this more than 20 hours of my time. I had no luck so
far.
I just cannot restore the database using any of -FIX_FSS_DATA and
-FIX_FSS_METADATA even with WIN1250, ISO8859_1 and other values.
I've prepared a test case just with one table, one column and one row -
just one database field with content from real database. I stripped the
real 10 GB database I have to just one field with real data and made a 14
kB backup file. The content is - dummy content, then string "WAYPOINT�S"
and then again dummy content. I cannot restore this simple one-field
database under Firebird 2.5 but I can restore it under Firebird 2.0. If you
can restore it under 2.5, let me know how you did that. If you cannot, I
will tell you how I correctly got this unrestorable content into the
database.
I would appreciate if any of you can test this for me - I've attached two
fbk files. I can restore the "can-be-restored.fbk" file but I cannot
restore the "cannot-be-restored.fbk" file. The only difference is the
string mentioned above "WAYPOINT�S". The difference can be tested with "fc"
on windows:
C:\>fc /b can-be-restored.fbk cannot-be-restored.fbk
Let me please know if you managed restoring the backup file and what
switches you used. Thank you a lot!
Man
I've already spent on this more than 20 hours of my time. I had no luck so
far.
I just cannot restore the database using any of -FIX_FSS_DATA and
-FIX_FSS_METADATA even with WIN1250, ISO8859_1 and other values.
I've prepared a test case just with one table, one column and one row -
just one database field with content from real database. I stripped the
real 10 GB database I have to just one field with real data and made a 14
kB backup file. The content is - dummy content, then string "WAYPOINT�S"
and then again dummy content. I cannot restore this simple one-field
database under Firebird 2.5 but I can restore it under Firebird 2.0. If you
can restore it under 2.5, let me know how you did that. If you cannot, I
will tell you how I correctly got this unrestorable content into the
database.
I would appreciate if any of you can test this for me - I've attached two
fbk files. I can restore the "can-be-restored.fbk" file but I cannot
restore the "cannot-be-restored.fbk" file. The only difference is the
string mentioned above "WAYPOINT�S". The difference can be tested with "fc"
on windows:
C:\>fc /b can-be-restored.fbk cannot-be-restored.fbk
Let me please know if you managed restoring the backup file and what
switches you used. Thank you a lot!
Man
On Tue, Mar 26, 2013 at 2:08 PM, Christian Mereles <chmereles@...>wrote:
> **
>
>
> Hi Dmitry,
>
> You're right, in my restore script I have something like:
>
> #!/bin/bash
>
> FBK=$1
> FDB=$2
>
> gbak *-r -k -v *$FBK $FDB -FIX_FSS_D ISO8859_1 -FIX_FSS_M ISO8859_1
> chown firebird.firebird $FDB
>
> I was just emphasizing the fix options: -FIX_FSS_D ISO8859_1 -FIX_FSS_M
> ISO8859_1
>
> Thanks.
>
> --
> Christian
>
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]