en:dbbackup
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
en:dbbackup [2020/12/10 07:30] – onyxadmin | en:dbbackup [2023/04/11 15:45] (current) – [Live Backup] onyxadmin | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | < | + | ====== Backup Concept====== |
- | < | + | <WRAP left nicebox blue> |
- | // collapse TOC | + | Setting up a backup for the data stored on the database server should be done immediately after installing the productive database instance in order to be able to restore all data quickly and completely in case of hardware and software cashes. \\ |
- | jQuery(document).ready(function() { | + | The proper implementation and activation of the selected backup concept is the responsibility of the user. |
- | jQuery('# | + | </ |
- | }); | + | |
- | </ | + | |
- | </ | + | |
- | ===== Backup Concept ===== | + | |
---- | ---- | ||
- | ==== Database Folders | + | ===== Directories to be backed up ===== |
- | All local and global data and settings are saved in the Onyx database on the server in folder | + | All local and global data and settings are located |
- | Alternatively, | + | If the paths for the database ..\OnyxDB |
+ | |||
+ | In order to back up all relevant data so that it can be restored without loss on the same or on a new computer in the event of a hardware or software problem, there are several | ||
+ | It is recommended to consult | ||
\\ | \\ | ||
+ | ---- | ||
+ | ===== File Backup ===== | ||
- | ==== Automatic Backup ==== | + | During a file backup the directories |
- | To configure the backup | + | * ..\OnyxDB and |
+ | * ..\Pictures | ||
+ | |||
+ | at their [[: | ||
+ | A differential backup is recommended only for the image path, while the database folder should always be copied completely. \\ | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | ++++Details| | ||
+ | ==== Backup Database Folder==== | ||
+ | Since the NexusDB database used by OnyxCeph³™ is an SQL database, the OnyxDB folder must not be copied | ||
+ | |||
+ | {{: | ||
\\ | \\ | ||
- | Once [[program_onyxdbserver|Onyx3Server]] | + | |
+ | After the backup | ||
+ | |||
+ | {{: | ||
\\ | \\ | ||
- | Recommended: | ||
- | * {{: | + | ==== Back up images folder==== |
- | * {{: | + | |
- | by an external backup tool to a mobile hard drive or rev cartridge | + | The folder(s) ..\Pictures contains all image data and can also be copied while the database program OnyxDBServer is running. The configured image paths can be read out in the user interface of the server program.\\ |
+ | |||
+ | {{: | ||
\\ | \\ | ||
+ | ++++ | ||
+ | ---- | ||
+ | ===== Live Backup ===== | ||
- | ==== Manual Backup ==== | + | During a live backup, the directories |
- | Open [[program_onyxdbserver|OnyxDBServer]] on tab |Backup/Manual| as described above and start a manual | + | * ..\Backup and |
+ | * ..\Pictures | ||
+ | |||
+ | are copied to a backup | ||
\\ | \\ | ||
- | ==== Restoring Data ==== | + | {{ : |
- | Open [[program_onyxdbserver|OnyxDBServer]] on tab |Backup/Manual| as described above and start data restore | + | ++++Details| |
+ | ==== Backup database folder==== | ||
+ | Instead of the database folder ..\OnyxDB, the backup folder preconfigured in the [[:program_onyxdbserver|database server program | ||
+ | So during live backup, unlike file backup, the database server OnyxDBServer does not need to be stopped and restarted after the copy operation is complete.\\ | ||
+ | \\ | ||
+ | |||
+ | ==== Backup | ||
+ | |||
+ | The folder(s) ..\Pictures contains all image data and can be copied even when the database program OnyxDBServer is running. The configured image paths can be read out in the user interface sof the server program.\\ | ||
+ | |||
+ | {{: | ||
+ | \\ | ||
+ | ++++ | ||
+ | |||
+ | ---- | ||
+ | ===== Manual | ||
+ | |||
+ | Open the user interface of the database program [[: | ||
+ | \\ | ||
+ | |||
+ | ===== Data restore ===== | ||
+ | |||
+ | Open the user interface of the database program [[: | ||
^Note ^ | ^Note ^ | ||
- | |Data can only be restored | + | |Data recovery |
- | |Backup | + | |The backup |
+ | |||
+ | ===== Disable backup ===== | ||
+ | |||
+ | If you back up the server directory daily anyway as part of an external backup, you should disable the internal backup in the [[: | ||
+ | |||
+ |
en/dbbackup.1607581846.txt.gz · Last modified: 2020/12/10 07:30 by onyxadmin