|
Compress / Uncompress Backups made by HBackup(..) Overview: In WinDev, the commands HBackup(..) and HRestoreBackup(..) give us the ability of backing up and restoring databases of HyperFileSQL Client/Server! The best of all is that one can do a backup while the database is in use. It takes a little longer but there’s no interruption of work. Using a HyperFileSQL C/S database for 24/7 is not a dream, it’s reality! But. All backups done by the HFCC (HyperFile Control Center) and those using the command HBackup(..) are simple copies of the database - no compression at all for the data! Backing up a 2,5 Gb database once a day will end up in 900 Gb of backups after just a single year! Being able to compress each backup to 120 Mb would result in a backup set of below 50 Gb after a year! HBackup(..) offers to run a stored procedure after completion of the backup. We’ll try to use that for compression after doing the backup. But: HRestoreBackup(..) does not offer to run a procedure before doing the restore and so we’ll have to run another stored procedure to uncompress the backup before restoring it to the database. Bad news: while HBackup(..) hands over the location of the backup to the stored procedure, HRestoreBackup(..) has no mechanism of locating a certain backup. We have to find the location of a certain backup on our own! To be continued .........  |
