{"id":46,"date":"2006-04-27T16:00:40","date_gmt":"2006-04-27T08:00:40","guid":{"rendered":"http:\/\/twycf.com\/wordpress\/archives\/46"},"modified":"2006-04-27T16:05:07","modified_gmt":"2006-04-27T08:05:07","slug":"firebird-%e8%b3%87%e6%96%99%e5%ba%ab%e5%a3%93%e7%b8%aecompact","status":"publish","type":"post","link":"https:\/\/twycf.com\/?p=46","title":{"rendered":"Firebird \u8cc7\u6599\u5eab\u58d3\u7e2e(Compact)"},"content":{"rendered":"<p>FireBird \u8cc7\u6599\u5eab\u5728\u4f7f\u7528\u4e00\u6bb5\u6642\u9593\u5f8c\uff0c\u6a94\u6848\u6703\u8d8a\u4f86\u8d8a\u5927\uff0c\u800c\u88e1\u9762\u7684 Garbage \u4e5f\u6703\u8d8a\u4f86\u8d8a\u591a\uff0c\u6709\u5169\u500b\u6b65\u9a5f\u53ef\u4ee5\u8b93 FireBird \u8cc7\u6599\u5eab\u6e1b\u80a5\uff0c\u5099\u4efd(backup)\u8207\u9084\u539f(restore)\u3002<!--more--><br \/>\n\u6b65\u9a5f\u4e00\uff1a\u5099\u4efd(backup)<br \/>\n<coolcode linenum=\"off\"><br \/>\nC:\\Firebird\\bin\\gbak -v -b -t -user SYSDBA -password &#8220;masterkey&#8221; c:\\firebird\\system.gdb system.fbk<\/coolcode><br \/>\n\u9019\u500b backup \u8cc7\u6599\u5eab\u6211\u6709\u7528 SQL Explorer \u9032\u53bb\u770b\uff0c\u53ef\u4ee5\u4f7f\u7528\u4e5f\u53ef\u4ee5\u4fee\u6539\uff0c\u4f46\u662f\u6700\u597d\u4e0d\u8981\u76f4\u63a5\u4f7f\u7528\uff0c\u56e0\u70ba\u4f7f\u7528\u4e0a\u8ff0\u6307\u4ee4\u518d\u5c0d\u9019\u500b backup \u8cc7\u6599\u5eab\u64cd\u4f5c\u6642\uff0c\u5f97\u5230\u7684\u932f\u8aa4\u8a0a\u606f\u63cf\u8ff0\u5982\u4e0b\u3002<br \/>\n<coolcode linenum=\"off\"><br \/>\ngbak: ERROR: file C:\\FIREBIRD\\SYSTEM.FBK is not a valid database<br \/>\ngbak: Exiting before completion due to errors<\/coolcode><br \/>\n\u9019\u8b49\u660e\u4e86 backup \u8cc7\u6599\u5eab\u7684\u5167\u5bb9\u4e0d\u9069\u5408\u62ff\u4f86\u5b58\u53d6\uff0c\u53ea\u9069\u5408\u5099\u4efd\u3002<br \/>\n\u6b65\u9a5f\u4e8c\uff1a\u9084\u539f(restore)<br \/>\n<coolcode linenum=\"off\"><br \/>\nC:\\Firebird>bin\\gbak -c -user SYSDBA -password &#8220;masterkey&#8221; c:\\firebird\\system.fbk system.gdb.ok<br \/>\n<\/coolcode><br \/>\n\u4e0a\u8ff0\u5099\u4efd\u53ca\u9084\u539f\u5169\u500b\u52d5\u505a\uff0c\u6211\u5011\u53ef\u4ee5\u7a31\u4ed6\u70ba\u8cc7\u6599\u5eab\u58d3\u7e2e(Database Compact)\uff0c\u5176\u5be6\u61c9\u8a72\u53eb\u505a\u8cc7\u6599\u5eab\u7dca\u5be6(Compact)\uff0c\u4f46\u5ff5\u8d77\u4f86\u6eff\u62d7\u53e3\u7684\u3002\u5b8c\u6210 Compact \u5f8c\uff0c\u53ef\u4ee5\u5c07\u6700\u5f8c\u7684\u8cc7\u6599\u5eab\u53d6\u4ee3\u539f\u672c\u7684\u8cc7\u6599\u5eab\u4e86\u3002<br \/>\n\u53c3\u8003\u7db2\u9801<br \/>\n<a href=\"http:\/\/www.destructor.de\/firebird\/gbak.htm\">GBAK &#8211; Firebird Backup and Restore<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>FireBird \u8cc7\u6599\u5eab\u5728\u4f7f\u7528\u4e00\u6bb5\u6642\u9593\u5f8c\uff0c\u6a94\u6848\u6703\u8d8a\u4f86\u8d8a\u5927\uff0c\u800c\u88e1\u9762\u7684 Garbage \u4e5f\u6703\u8d8a\u4f86\u8d8a\u591a\uff0c\u6709\u5169\u500b\u6b65\u9a5f\u53ef [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-46","post","type-post","status-publish","format-standard","hentry","category-windows"],"_links":{"self":[{"href":"https:\/\/twycf.com\/index.php?rest_route=\/wp\/v2\/posts\/46","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/twycf.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/twycf.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/twycf.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/twycf.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=46"}],"version-history":[{"count":0,"href":"https:\/\/twycf.com\/index.php?rest_route=\/wp\/v2\/posts\/46\/revisions"}],"wp:attachment":[{"href":"https:\/\/twycf.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=46"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/twycf.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=46"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/twycf.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}