Firebird数据库的串行表转储备份
Firebird Database Backup by Serialized Database Table Dump
摘要:
本文介绍了一个简单的数据转储和加载工具的火鸟数据库,模仿MySQL中的mysqldump。这个实用程序fb_dump和fb_load分别用于转储和加载,使用kinterbasdb检索每个数据库表,并使用marshal模块序列化数据。与标准Firebird数据库备份实用程序gbak相比,该实用程序有两个优点。首先,它能够备份和恢复单个数据库表,这可能有助于恢复损坏的数据库。其次,输出是文本编码格式的(来自marshal模块),这使得它比压缩文本备份更有弹性,就像使用gbak的情况一样。
英文摘要:
This paper presents a simple data dump and load utility for Firebird databases which mimics mysqldump in MySQL. This utility, fb_dump and fb_load, for dumping and loading respectively, retrieves each database table using kinterbasdb and serializes the data using marshal module. This utility has two advantages over the standard Firebird database backup utility, gbak. Firstly, it is able to backup and restore single database tables which might help to recover corrupted databases. Secondly, the output is in text-coded format (from marshal module) making it more resilient than a compressed text backup, as in the case of using gbak.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。