Recent

Author Topic: [Firebird] Verify, remote backup and restore  (Read 2388 times)

SymbolicFrank

  • Hero Member
  • *****
  • Posts: 639
[Firebird] Verify, remote backup and restore
« on: December 04, 2015, 10:52:27 pm »
I would have really liked this title to be just [recommend me a database that has the best tools I can manage from my Lazarus/fpc program], but I haven't got that freedom. Firebird it has to be, and (for now?) version 1.5.

I tried to validate databases with gfix. I have no way of judging its output, so it fails in doing that. It tends to finish in 0..~ seconds, with an errorlevel of 0. ?

I tried to repair a (suspected) corrupt database with gfix, but the result was still a (suspected) corrupt database.

I tried to backup and restore that database with gbak. The result was a database that was missing tables and fields, without any notification.

I really, Really want to back up many databases to a remote location and verify their integrity. But I have no idea of how to do that.

Groffy

  • Full Member
  • ***
  • Posts: 210
Re: [Firebird] Verify, remote backup and restore
« Reply #1 on: December 05, 2015, 07:35:29 am »
I tried to validate databases with gfix. I have no way of judging its output, so it fails in doing that. It tends to finish in 0..~ seconds, with an errorlevel of 0. ?

You can't see or redirect the console output when trying to connect with gbak? It seems that its not possible to connect to the database at all
Linux Mint 18.3 - KDE / Windows 10 / Lazarus 2.0.6 / trunk -qt

SymbolicFrank

  • Hero Member
  • *****
  • Posts: 639
Re: [Firebird] Verify, remote backup and restore
« Reply #2 on: December 09, 2015, 02:27:50 pm »
Regularly, gfix is ready in less than a second. There is no console output and the ERRORLEVEL is 0, which would indicate success. In the other cases, it takes from multiple seconds up to many minutes. And there is no console output, with an ERRORLEVEL of 0.

I cannot distinguish success on the time it takes, because that varies quite a bit between successive runs on the same database.

The only times I get an error message is when the database is not found or in use.

So, it seems that gfix stops/crashes on certain errors, without notification. And I don't know if it is supposed to print a message on success.

 

TinyPortal © 2005-2018