{"id":23,"date":"2010-07-15T20:47:14","date_gmt":"2010-07-15T20:47:14","guid":{"rendered":"http:\/\/sqlornosql.10sa.com\/?p=23"},"modified":"2010-07-16T09:11:38","modified_gmt":"2010-07-16T09:11:38","slug":"downgrade-firebird-from-2-x-into-1-5-x","status":"publish","type":"post","link":"http:\/\/10sa.com\/sql_stories\/?p=23","title":{"rendered":"Downgrade firebird from 2.x into 1.5.x"},"content":{"rendered":"<p>Uniquely, downgrade is required. That happened in my production environment.<br \/>\nIn generally, there is no official tools supporting such operation however I found on some forum solution which I successfuly tested.<\/p>\n<p>The clue is to make backup with tool gbak derived from version you wish to downgrade (in my situation it is 1.5.6).<\/p>\n<p>First of all, you need to prepare server for this operation.<br \/>\nEdit config file (usually \/opt\/firebird\/firebird.conf) and change variable to<\/p>\n<pre lang=\"bash\">\r\nRemoteBindAddress=127.0.0.1\r\n<\/pre>\n<p>Now, restart server.<br \/>\nFor your security, try to properly close your data. Do this with original gbak tool.<\/p>\n<pre lang=\"bash\">\r\n\/opt\/firebird\/bin\/gfix $Database -user $User -password $Passwd -commit all\r\n\/opt\/firebird\/bin\/gfix $Database -user $User -password $Passwd -shut single -tran 180\r\n\/opt\/firebird\/bin\/gfix $Database -user $User -password $Passwd -shut single -force 120\r\n\/opt\/firebird\/bin\/gfix $Database -user $User -password $Passwd -validate -full\r\n\/opt\/firebird\/bin\/gfix $Database -user $User -password $Passwd -mend -full -ignore\r\n<\/pre>\n<p>Now, you can make main operation, backup with gbak from version you are downgrading. I simply copied this application from version 1.5.6 of the Firebird RDBMS and saved it as gbak156 into firebird \/bin directory.<\/p>\n<pre lang=\"bash\">\r\n\/opt\/firebird\/bin\/gbak156 -g -ig -b -k -e -v -t -user $User -password $Passwd $Database $DatabaseDestination\r\n<\/pre>\n<p>If everything goes ok you have backup of your data which are conform to version of 1.5.6 &#8211; simply move new craeted file into destination server with Firebird 1.5.6 and restore your data, e.g.<\/p>\n<pre lang=\"bash\">\r\n\/opt\/firebird\/bin\/gbak -b -g -ig -e -v -t -user $User -password $Passwd $Database $Backupfile\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Uniquely, downgrade is required. That happened in my production environment. In generally, there is no official tools supporting such operation however I found on some forum solution which I successfuly tested. The clue is to make backup with tool gbak derived from version you wish to downgrade (in my situation it is 1.5.6). First of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6,3],"tags":[4],"_links":{"self":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/23"}],"collection":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=23"}],"version-history":[{"count":12,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/23\/revisions"}],"predecessor-version":[{"id":55,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/23\/revisions\/55"}],"wp:attachment":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}