ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / Managing HFSQL Client/Server
  • Overview
  • Restoring a backup in the HFSQL Control Center
  • Restoring a backup through 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/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Restoring an HFSQL Client/Server database
HFSQL Client/ServerAvailable only with this kind of connection
Overview
A backup of an 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 only, there must be no connection on the database to restore.
Remark: Performing a backup and restoring it under a different name allows you to easily duplicate a database.
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.
Remarks:
  • You also have the ability to restore a backup found in a specific server directory. 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 through programming

To restore a database backup

Use the HRestoreBackup function.

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 with HRestoreBackup.
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help