How to backup file objects? Can users restore a database without backing up file objects? (DBMR2241)

~ 0 min
2016-03-18 03:22

Users can specify the file object (FO) backup mode by setting the keyword DB_BkFom for a full backup.

Ÿ   DB_BkFoM = 0: Don’t back up file objects

Ÿ   DB_BkFoM = 1: Back up system file objects only

Ÿ   DB_BkFoM = 2: Back up both system file objects and user file objects

When a full backup is performed, an FO directory is created under the backup directory. If the value of DB_BkFom equals 1, only system file objects are copied into the FO directory; if the value of DB_BkFom equals 2, both system file objects and user file objects are copied into the FO directory. The backed-up file objects are renamed sequentially when they are copied into the FO directory. For example, if the name of the original external file are “ZZ000001.bmp,... , ZZ00AB32.txt”, the backup server would copy them into the FO subdirectory and rename them “fo0000000000.bak,... , fo0000002345.bak”', meaning they are the 1st file object and the 2345th file object. The mapping between the source full file name and its new name is recorded in the file object mapping list file, dmFoMap.his. It is a pure ASCII text file and necessary for restoring file objects. The format is as follows.

Database Name: DBSAMPLE5

Begin Backup FO Time: 2012/01/29 09:21:32

FO Backup Directory: C:\DBMaker\5.2\SAMPLES\DATABASE\backup\FO\

[Mapping List]

s, fo0000000000.bak, "C:\DBMaker\5.2\SAMPLES\DATABASE\backup\FO\ZZ000001.bmp"

u, fo0000000001.bak, "C:\DBMaker\5.2\SAMPLES\DATABASE\backup\FO\image.jpg"

....

s, fo0000002345.bak, "C:\DBMaker\5.2\SAMPLES\DATABASE\backup\FO\ZZ00AB32.txt"

If the value of DB_BkFom equals 0, the database also can be restored without backing up file objects. However, users should notice that when restore the database to another new database, if the value of DB_BkFom equals 0, users need to manually copy both system file objects and user file objects into the FO directory, and if the value of DB_BkFom equals 1, users only need to manually copy the user file objects into the FO directory. Users can refer the listed file in dmFoMap.his to ensure all related directory exist.

 

Version: DBMaker 4.x/5.x

Product: Bundle/Normal

Platform: Windows/Linux

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags