Dear, How to generate a cold backup of the database, thanks [Non-text portions of this message have been removed]...
121795
Marco Sucuzhañay
marcosucuzhanay
May 22, 2013 8:20 pm
When generating a backup of the database shows me the message: gbak: ERROR database file appears corrupt() gbak: ERROR wrong page type gbak: ERROR page...
121796
Helen Borrie
helebor
May 22, 2013 9:56 pm
... It is possible that the database file is not corrupt, but contains a database with the wrong on-disk format for the version of gbak you are trying to use. ...
121797
Marco Sucuzhañay
marcosucuzhanay
May 22, 2013 10:30 pm
Thanks for the reply, the problem appears to me to create a backup of the database, which has 650 Gigas hot, I can do it in COLD backup? 2013/5/22 Helen Borrie...
121798
fabianoaspro
May 22, 2013 10:53 pm
Yes Em 22/05/2013 19:30, "Marco Sucuzhañay" <msucuzhanay.activa@...> ... [Non-text portions of this message have been removed]...
121799
Norman Dunbar
normandunbar
May 23, 2013 7:35 am
... You can download a PDF manual for the gbak application at http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-gbak.pdf ...
121800
Norman Dunbar
normandunbar
May 23, 2013 7:55 am
Morning Berrie, ... Access is a desktop "database" and isn't really suited to one database being shared by numerous people. It can be done, but for 150 users?,...
121801
Mark Rotteveel
mark@...
May 23, 2013 8:24 am
On Wed, 22 May 2013 17:30:31 -0500, Marco Sucuzhañay ... the ... What do you mean with cold backup? Mark...
121802
tomkrej
May 23, 2013 8:31 am
Hi, I'd like to get the count of all types of db pages. If I run the query select count(*), rdb$page_type from rdb$pages group by rdb$page_type I got only...
121803
Norman Dunbar
normandunbar
May 23, 2013 9:34 am
Morning Tomas, ... Unfortunately, you can't! This thread might help explain. http://sourceforge.net/mailarchive/message.php?msg_id=27114737 Cheers, Norm. -- ...
121804
fabianoaspro
May 23, 2013 11:01 am
Take a look at the rdb$database table. It contains the total ammount pages of the entire database. ... [Non-text portions of this message have been removed]...
121805
Fabiano Kureck
fabianoaspro
May 23, 2013 11:21 am
Sorry is not rdb$database but another system table. I can´t remember its name… De: firebird-support@yahoogroups.com ...
121806
Stefan Heymann
stefanheymann
May 23, 2013 12:49 pm
... No. Test 3 proves that the case insensitive comparison for 'Fu' and 'fu' works correctly. But as soon as you include the "Sharp S" character (comparing...
121807
Craig Cox
data.inspector
May 23, 2013 2:09 pm
FB 2.5 SQL Query using IBExpert (Stand alone), and using IBObjects (in a Delphi Application). I have a double precision field that contains a value of...
121808
Ann Harrison
annwharrison
May 23, 2013 4:27 pm
On Wed, May 22, 2013 at 4:20 PM, Marco Sucuzhañay < ... Hmm. The first thing I would try is a backup with the -g option. The problem may be in an old...
121809
Ann Harrison
annwharrison
May 23, 2013 5:04 pm
... The easy answer is to use gstat which will tell you how many pages are used by data and indexes for each table. It does not track blobs that are larger...
121810
tatihulot
May 23, 2013 7:36 pm
Hello. I just discovered Firebird early this morning, and have spent a portion of today researching it. There is one question I have about it. I'm not 100% if...
121811
Alexey Kovyazin
alexey.kovyazin
May 24, 2013 4:32 am
Hi, You can use our free product DBInfo http://ib-aid.com/products/firebird_interbase/monitoring/dbinfo Also, you can divide size of your database in bytes to...
121812
Tomas Krejzek
krejzet
May 24, 2013 5:57 am
Hi Alexey, thank you for this tool, it do exactly what I want. I calculate the size of database from mon$database - as number * size of pages - so total count...
121813
sir_wally_lewis
May 24, 2013 6:52 am
Does anyone know what this means? Simply trying to open a dataset and I get this error just after the system simply stops. Server Version: LI-V6.3.1.26351...
121814
Helen Borrie
helebor
May 24, 2013 7:05 am
... Firebird is a database management system, not a file manager. Specifically, it manages relational databases. It doesn't come with any GUI...for one...
121815
Mark Rotteveel
mark@...
May 24, 2013 7:14 am
On Thu, 23 May 2013 16:09:56 -0000, "tatihulot" <forums@...> ... of ... GUI ... trying ... a ... conditional ... Firebird is a relational database...
121816
hvlad
fbvlad
May 24, 2013 9:27 am
... For CHAR(20) data type you must supply buffer of 20 bytes per item. Or you could leave this C-data as is but modify data type at array descriptor returned...
121817
un_spoken
May 24, 2013 1:20 pm
Hello. If I perform an update/ insert/ delete query on a given table does Firebird is storing somewhere the time of last change on this table? Or something...
121818
un_spoken
May 24, 2013 1:34 pm
PS. I do not need to know what record was changed as last. So maybe there is other solution than: http://www.firebirdfaq.org/faq77/....
121819
Ann Harrison
annwharrison
May 24, 2013 2:24 pm
... No. ... No. ... No. (I guess that was obvious.) ... Create a table that consists of just a LastChanged column. Put a multi-function trigger on the...
121820
tatihulot
May 24, 2013 6:24 pm
Thank you all for your responses. I have, yes, used Open Office and Libre Office. Jd...
121821
Svein Erling Tysvær
svein_erling
5:42 am
... Have you considered using events? HTH, Set...
121822
Andy Samuel
ASOrg
8:23 am
Hi All ! Anybody knows on how to install version 3 ? I know it's not even beta version. Looking at the files, there are batch files of install_classic and...
121823
Thomas Steinmaurer
iblogmanager
9:15 am
Andy, ... You'd better ask 3.0 related questions in the firebird-devel list. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and...