|
|
|
|
|
|
|
|
|
|
- Overview
- Interactive mode
- Saving the HFSQL data files associated with an analysis
- Command Line mode
- Saving all the data files found in a WDD file or in a .REP file
- Saving all the data files found in an HFSQL Client/Server database
- Saving all the data files found in a list
WDLog: Backup of HFSQL data files
  Available only with these kinds of connection
WDLog allows you to save all the HFSQL data files used by a WINDEV or WEBDEV application. The following file is required to perform this backup: - the analysis file (.WDD),
- the .REP file that contains the different paths of the data files managed by the project.
This backup can be performed: - In interactive mode (WDLog is started).
- In "Command line" mode. The "Command line" mode allows you to include the management of file backups in your applications. In this case, no specific operation must be performed by the user.
Important Don't forget to note the references of all backups (date of backup, backup directory, type of backup, location of backup, etc.). This information is essential for restoring data files. Saving the HFSQL data files associated with an analysis To save the HFSQL data files associated with an analysis: - Start WDLog.
- Select "Backups .. Save the data" (or click the orange arrow).
- With the "Browse" button, select:
- The analysis file (.WDD) that contains the description of data files managed by the project.
- The .REP file that contains the different paths of the data files managed by the project.
- The list of data files found in the application .REP is displayed. In this list, you can:
- Delete HFSQL data files (.FIC, .MMO or .NDX files) with the "Remove" button.
- Add HFSQL data files (.FIC, .MMO or .NDX files) with the "Other" button.
- Save the list of data files in a "List" file (LST extension) with the "Save" button. This list file can be read by WDLog or used in command line.
Warning: The "list" file is not emptied each time you save. - Open a list of data files with the "Open" button.
- Click the "OK" button to validate the backup of data files.
- Specify the following elements in the backup window:
- Backup directory: Directory in which the backup directory will be created.
- Backup name: Name of the directory in which the backup will be made.
- Specify the backup options:
- Do not create a subdirectory of the backup name The backup directory is not created.
- Compression compresses files during backup. This option is used to reduce the storage size of backups. A single archive file (WDZ) will be created.
If this option is not checked, the files will only be copied into the backup directory. - Multi-volume compact files during backup and group files in 1.4 MB archives. This option automatically enables the "Compression" mode.
- Do not save indexes (.NDX) Reduce backup size. If this option is checked, the files must be reindexed once they have been restored.
Reminder: WINDEV offers various solutions for reindexing data files: WDTool (not redistributable), WDOptimizer, WDMAP (not redistributable), or by programming with the WLanguage function HIndex. - Do not lock files Save files: saves files even when they are in use. This option is not recommended because the backup may contain locked records that can no longer be accessed.
This option is recommended in some rare cases (for applications run in background task that open files but that do not use transactions for instance). This option can also be used with applications that handle independent data files (not linked in the analysis).
- Click the "OK" button to start the backup.
Two types of backups are available in command line mode: - Saving all the data files described either in an analysis, or in the .REP file of the application.
- Saving a list of data files.
For more details, see the previous paragraph ("Interactive mode"). Note A WDLog.LOG file is automatically created. This file contains the operations performed. Saving all the data files found in a WDD file or in a .REP file The following syntax allows you to save all the data files found in a WDD file or in a .REP file: WDLog /APPLI=<FullWDDName or FullREPName>
/REP = <BackupDir>
/COMPRESS = <True/False>
/MUET = <True/False>
/MULTI = <True/False>
/SANSBLOCAGE = <True/False>
/SANSINDEX = <True/False>
/SANSSOUSREP = <True/False> Details of parameters: | | | Parameter | Meaning |
|---|
| /APPLI = <FullWDDName or FullREPName> | Character string containing the full name of the analysis (".WDD" file) or the full name of the ".REP" file of the application. | | /REP=<BackupDir> | Path where the files will be saved | | /COMPRESS=<True/False> | The data files will be compressed if this option is set to "True". The files will be saved in an archive (.WDZ file).
Otherwise, the files will not be compressed.
This option is set to "True" by default. | | /MUET=<True/False> | If this option corresponds to "True", if a locking error occurs, all the operations performed will be written into a result file (.LOG file). The execution of WDLog will not be locked.
Otherwise, a window will be displayed if an error occurs.
This option is set to "False" by default. | | /MULTI=<True/False> | The backup archive will be divided into files (1.4 MB) if this option is set to "True". There is no need to specify the compression option if this option is used.
Otherwise, the archive will not be divided.
This option is set to "False" by default. | | /SANSBLOCAGE=<True/False> | Only the data files that are not locked will be saved if this option is set to "True".
Otherwise, all the data files will be saved.
This option is set to "False" by default. | | /SANSINDEX=<True/False> | The indexes of the data files will not be saved if this option is set to "True".
Otherwise, the indexes will be saved.
This option is set to "False" by default. | | /SANSSOUSREP=<True/False> | The backup subdirectory will not be created if this option is set to "True". The backup will be performed in the <BackupDir> directory.
Otherwise, a backup subdirectory will be created.
This option is set to "False" by default. |
Example The following command line saves all the files from the "C:\MyProject\MyAnalysis.WDD" analysis in the "D:\Save my projects" directory. These files will be compressed. The index files will not be saved. Warning If directory names use spaces, the parameter must be enclosed in quotation marks. ExeRun("WDLog /APPLI= C:\MyProject\MyAnalysis.WDD " + ...
"/REP=""D:\Backup of my projects"" /COMPRESS=True /SANSINDEX=True")
Saving all the data files found in an HFSQL Client/Server database To save all the data files found in an HFSQL Client/Server database, use the following syntax: WDLog /SERVEUR = <Server Name> /BD = <Database name> /NOM = <Username> /MDP_DB = <Password> /REP = <BackupDir> /COMPRESS = <True/False> /MUET = <True/False> /MULTI = <True/False> /SANSSOUSREP = <True/False> /LISTE = <FileName> /APPLI = <AppName> Details of parameters: | | | Parameter | Meaning |
|---|
| /SERVEUR=<Server name> | Character string containing the name or IP address of the HFSQL Client/Server server. | | /BD = <Database name> | Character string containing the name of the HFSQL Client/Server database to save. | | /NOM = <Username> | Character string containing the name of the user who connects to the database. | | /MDP_DB = <Password> | Character string containing the password associated with the user for the database. | | /REP=<BackupDir> | Path where the files will be saved | | /COMPRESS=<True/False> | The data files will be compressed if this option is set to "True". The files will be saved in an archive (.WDZ file).
Otherwise, the files will not be compressed.
This option is set to "True" by default. | | /MUET=<True/False> | If this option corresponds to "True", if a locking error occurs, all the operations performed will be written into a result file (.LOG file). The execution of WDLog will not be locked.
Otherwise, a window will be displayed if an error occurs.
This option is set to "False" by default. | | /MULTI=<True/False> | The backup archive will be divided into files (1.4 MB) if this option is set to "True". There is no need to specify the compression option if this option is used.
Otherwise, the archive will not be divided.
This option is set to "False" by default. | | /SANSSOUSREP=<True/False> | The backup subdirectory will not be created if this option is set to "True". The backup will be performed in the <BackupDir> directory.
Otherwise, a backup subdirectory will be created.
This option is set to "False" by default. | | /LISTE = <FileName> | Full name of the file containing the list of data files to save. This text file contains one file name per line. It can be created by WDLog ("Save" button).
Example:
E:\WD Stock Chart\Exe\Action.FIC
E:\WD Stock Chart\Exe\Share2000.FIC
E:\WD Stock Chart\Exe\Rate.FIC
| | /APPLI=<AppName> | Name of the application that will be used to identify the backup ("Automatic backup of " + <AppName>). |
Example The following command line saves all the files in the "MabaseHF" database in the "D:\Save my projects" directory. These files will be compressed. The index files will not be saved. ExeRun("WDLog /SERVEUR=123.123.123.1" + "/BD=MaBaseHF /NOM=Flo /MDP_DB=Test" + ...
"/REP=""D:\Saving my projects""" + ...
"/COMPRESS=True /SANSINDEX=True /APPLI=MaBaseHF")
Saving all the data files found in a list To save a list of data files, create a text file containing the different physical names of the files to save. This file can be created by WDLog run in interactive mode. The command line is as follows: WDLog /LISTE = <FileName>
/REP = <BackupDir>
/COMPRESS = True
/MUET = True
/MULTI = True
/SANSBLOCAGE = True
/SANSINDEX = True
/SANSSOUSREP = True The table below presents the different elements that can be found on the command line: | | | Parameter | Meaning |
|---|
| /LISTE = <FileName> | Name of the file containing the list of data files to save. This text file contains one file name per line. It can be created by WDLog ("Save" button).
Example:
E:\WD Stock Chart\Exe\Action.FIC
E:\WD Stock Chart\Exe\Share2000.FIC
E:\WD Stock Chart\Exe\Rate.FIC | | /REP=<BackupDir> | Path where the files will be saved | | /COMPRESS=True | The data files will be compressed if this option is set to "True". The files will be saved in an archive (.WDZ file) | | /MUET=True | If this option corresponds to "True", if a locking error occurs, all the operations performed will be written into a result file (.LOG file). The execution of WDLog will not be locked. | | /MULTI=True | The backup archive will be divided into files (1.4 MB) if this option is set to "True". There is no need to specify the compression option if this option is used. | | /SANSBLOCAGE=True | Only the data files that are not locked will be saved if this option is set to "True". | | /SANSINDEX=True | The indexes of the data files will not be saved if this option is set to "True". | | /SANSSOUSREP=True | The backup subdirectory will not be created if this option is set to "True". The backup will be performed in the <BackupDir> directory. |
Example The following command line saves the data files in the list "C:\MaListe.LST" in the directory "D:\Backup" directory. The files currently used will not be saved. ExeRun("WDLog /LISTE=C:\MyList.LST /REP=D:\Backup/SANSBLOCAGE=True")
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|