Re: [firebird-support] Restoring backup from 2.5 to 2.1

2012-07-06 Thread Milan Babuskov
Aldo Caruso wrote:
When I try to restore a backup done in a 2.5 firebird server to a 2.1 
 firebird server, I get the following error message:
 
 gbak:transportable backup -- data in XDR format
 gbak: ERROR:Expected backup version 1..8.  Found 9
 gbak:Exiting before completion due to errors
 
Isn't it possible to restore a backup database from a 2.5 to a 2.1 
 firebird server ?

It is not possible since 2.5 introduces incompatible changes. If you 
need to move from 2.5 back to 2.1, the only way would be to copy data 
from one database into another. I tried this in the past and met with 
another problem: which version to use to access the databases for copy. 
IIRC, 2.5 did alter the database structure so I could not use it with 
2.1. The final solution was to start up the source database on 2.5 
server and prepare a clean database on a different machine with 2.1 
server. And then I copied the data using FBCopy tool.

To prepare a clean database, you can use something like isql -x to 
dump the database schema from 2.5, and then run that script on an empty 
database with Firebird 2.1.

Good luck.

-- 
Milan Babuskov

==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==



[firebird-support] Restoring backup from 2.5 to 2.1

2012-07-04 Thread Aldo Caruso
Hi,

   When I try to restore a backup done in a 2.5 firebird server to a 2.1 
firebird server, I get the following error message:

gbak:transportable backup -- data in XDR format
gbak: ERROR:Expected backup version 1..8.  Found 9
gbak:Exiting before completion due to errors

   Isn't it possible to restore a backup database from a 2.5 to a 2.1 
firebird server ?

Thanks  in advance,
Aldo






Re: [firebird-support] Restoring backup from 2.5 to 2.1

2012-07-04 Thread Thomas Steinmaurer
 When I try to restore a backup done in a 2.5 firebird server to a 2.1
 firebird server, I get the following error message:

 gbak:transportable backup -- data in XDR format
 gbak: ERROR:Expected backup version 1..8.  Found 9
 gbak:Exiting before completion due to errors

 Isn't it possible to restore a backup database from a 2.5 to a 2.1
 firebird server ?

Are you using gbak from 2.1 against a 2.5 server and I hope you don't 
use any new/specific things from 2.5?

-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/


Re: [firebird-support] Restoring backup from 2.5 to 2.1

2012-07-04 Thread Alexandre Benson Smith
Did you tried to use 2.1 gbak against 2.5 server to produce the gbk ?

see you !

Em 4/7/2012 15:59, Aldo Caruso escreveu:
 To restore, I am using gbak 2.1 against a 2.1 server, but reading a
 *.fbk backup file that was created using a 2.5 server.
 AFAIK I'm not using specific things from 2.5

 Thanks,
 Aldo

 El 04/07/12 13:56, Thomas Steinmaurer escribió:
 When I try to restore a backup done in a 2.5 firebird server to a 2.1
 firebird server, I get the following error message:

 gbak:transportable backup -- data in XDR format
 gbak: ERROR:Expected backup version 1..8. Found 9
 gbak:Exiting before completion due to errors

 Isn't it possible to restore a backup database from a 2.5 to a 2.1
 firebird server ?
 Are you using gbak from 2.1 against a 2.5 server and I hope you don't
 use any new/specific things from 2.5?

 -- 
 With regards,
 Thomas Steinmaurer
 http://www.upscene.com/





 [Non-text portions of this message have been removed]



 

 ++

 Visit http://www.firebirdsql.org and click the Resources item
 on the main (top) menu.  Try Knowledgebase and FAQ links !

 Also search the knowledgebases at http://www.ibphoenix.com

 ++
 Yahoo! Groups Links








Re: [firebird-support] Restoring backup from 2.5 to 2.1

2012-07-04 Thread Aldo Caruso
Good idea, but it is unfeasible for me because the server is remote on 
Internet (with very high latency), so I have to create the back ups on 
the server, download the file and apply it to my local machine (which 
has firebird 2.1)

Thanks,
Aldo

El 04/07/12 16:04, Alexandre Benson Smith escribió:

 Did you tried to use 2.1 gbak against 2.5 server to produce the gbk ?

 see you !

 Em 4/7/2012 15:59, Aldo Caruso escreveu:
  To restore, I am using gbak 2.1 against a 2.1 server, but reading a
  *.fbk backup file that was created using a 2.5 server.
  AFAIK I'm not using specific things from 2.5
 
  Thanks,
  Aldo
 
  El 04/07/12 13:56, Thomas Steinmaurer escribió:
  When I try to restore a backup done in a 2.5 firebird server to a 2.1
  firebird server, I get the following error message:
 
  gbak:transportable backup -- data in XDR format
  gbak: ERROR:Expected backup version 1..8. Found 9
  gbak:Exiting before completion due to errors
 
  Isn't it possible to restore a backup database from a 2.5 to a 2.1
  firebird server ?
  Are you using gbak from 2.1 against a 2.5 server and I hope you don't
  use any new/specific things from 2.5?
 
  --
  With regards,
  Thomas Steinmaurer
  http://www.upscene.com/
 
 
 
 
 
  [Non-text portions of this message have been removed]
 
 
 
  
 
  ++
 
  Visit http://www.firebirdsql.org and click the Resources item
  on the main (top) menu. Try Knowledgebase and FAQ links !
 
  Also search the knowledgebases at http://www.ibphoenix.com
 
  ++
  Yahoo! Groups Links
 
 
 
 

 




[Non-text portions of this message have been removed]



Re: [firebird-support] Restoring backup from 2.5 to 2.1

2012-07-04 Thread Helen Borrie

El 04/07/12 16:04, Alexandre Benson Smith escribió:

 Did you tried to use 2.1 gbak against 2.5 server to produce the gbk ?

At 07:11 AM 5/07/2012, Aldo Caruso wrote:
Good idea, but it is unfeasible for me because the server is remote on 
Internet (with very high latency), so I have to create the back ups on 
the server, download the file and apply it to my local machine (which 
has firebird 2.1)

Then it cannot possibly work.  Firebird does *not* support back-porting 
databases.  It was found to be possible (sometimes) to backup and restore 
between 2.1 and 2.0, only if the v.2.0 gbak was running in the v.2.1 server to 
make the backup.

If you have a copy of The Firebird Book Second Edition, you can read up on this 
in Chapter 5, Migration Issues.

./heLen



RE: [firebird-support] Restoring backup from 2.5 to 2.1 - Email found in subject

2012-07-04 Thread Leyne, Sean
 Good idea, but it is unfeasible for me because the server is remote on
 Internet (with very high latency), so I have to create the back ups on the
 server, download the file and apply it to my local machine (which has firebird
 2.1)

You could copy the v2.1 GBAK executable onto the remote machine, into a 
separate folder from the existing FB install.  

Then create a local backup using that executable.  That would create a v2.1 
backup of the database.


Sean



Re: [firebird-support] Restoring backup from 2.5 to 2.1 - Email found in subject

2012-07-04 Thread Aldo Caruso
Thanks for your idea.

Aldo

El 04/07/12 16:49, Leyne, Sean escribió:

  Good idea, but it is unfeasible for me because the server is remote on
  Internet (with very high latency), so I have to create the back ups 
 on the
  server, download the file and apply it to my local machine (which 
 has firebird
  2.1)

 You could copy the v2.1 GBAK executable onto the remote machine, into 
 a separate folder from the existing FB install.

 Then create a local backup using that executable. That would create a 
 v2.1 backup of the database.

 Sean

 




[Non-text portions of this message have been removed]