PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Restoring a backup in the HFSQL Control Center
  • Restoring a backup by programming
  • To restore a database backup
  • Tip: Using a backup to copy and rename a database
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
A backup of a HFSQL Client/Server database can be restored at any time:
  • if the backup performed is a full backup, all you have to do is restore this backup.
  • if the backup performed is a differential backup, all you have to do is restore the full backup and the associated differential backup.
Reminder: The differential backup contains all the modifications performed since the previous full backup.
The restore operation can be triggered:
Caution: Restoring a backup must be done with great care.
  • To perform this operation, you must have the rights to perform a backup (hRightsBackup constant) as well as the rights to lock the database (hRightsLock constant).
  • To restore the entire server (or the __jnl and __trs databases), no other application must be connected to the server. The connection used must not be attached to a database.
  • To restore databases, no connection must be established on the database to restore.
Note: Performing a backup and restoring it under a different name allows you to easily duplicate a database.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Restoring a backup in the HFSQL Control Center
To restore a backup:
  1. Select the HFSQL Client/Server server in the tree structure on the left of the screen.
  2. Select the "Backups" tab.
  3. In the table of existing backups, select the backup to restore.
  4. Click the "Restore the backup" button.
  5. Validate the restore operation.
Notes:
  • You also have the ability to restore a backup found in a specific directory of the server. To do so, click the "Restore a backup from a directory" button.
  • If the backup is restored on a network disk (UNC or network drive letter), the necessary rights must have been granted to the user.
    In this case, to perform the restore operation:
    • specify a UNC path for the backup location,
    • modify the properties of the HFSQL Client/Server server via the Windows service manager by specifying a user who has the necessary rights in order to access the UNC location containing the backup.
Restoring a backup by programming

To restore a database backup

Tip: Using a backup to copy and rename a database

To copy and rename a database, you have the ability to use the following tip:
  1. Perform the backup the database.
  2. Restore the database backup under a different name.
This operation can be performed by HRestoreBackup.
Minimum required version
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment