2020年01月30日

Firebirdで壊れたDBの修復


gfix -m -user sysdba -password masterkey bkmkapp.fdb
gbak -b -e -g -user sysdba -password masterkey bkmkapp.fdb newdb.fdb


cd /opt/firebird/bin

gfix -m -user sysdba -password masterkey /var/FbSQL/bkmkapp.fdb

gbak -b -e -g -user sysdba -password masterkey /var/FbSQL/bkmkapp.fdb /var/FbSQL/newdb.fdb


./isql -u sysdba -p masterkey




---------------------------
IBConsole ANSI Edition (32bit)
---------------------------
database file appears corrupt ()

wrong page type

page 130134 is of wrong type (expected 6, found 5)
---------------------------
OK   
---------------------------

10.png




posted by a23 at 07:56| Comment(0) | Firebird

2020年01月23日

ERROR: value too long for type character varying(3)

ERROR: value too long for type character varying(3)

文字タイプの可変には長すぎる値(3)
posted by a23 at 15:17| Comment(0) | PostgreSQL