Skip to content
GitLab
Explore
Sign in
Primary navigation
Search or go to…
Project
I
iml-backup
Manage
Activity
Members
Labels
Plan
Issues
Issue boards
Milestones
Wiki
Code
Merge requests
Repository
Branches
Commits
Tags
Repository graph
Compare revisions
Snippets
Build
Pipelines
Jobs
Pipeline schedules
Artifacts
Deploy
Releases
Container registry
Model registry
Operate
Environments
Monitor
Incidents
Analyze
Value stream analytics
Contributor analytics
CI/CD analytics
Repository analytics
Model experiments
Help
Help
Support
GitLab documentation
Compare GitLab plans
Community forum
Contribute to GitLab
Provide feedback
Keyboard shortcuts
?
Snippets
Groups
Projects
Show more breadcrumbs
IML Open Source
iml-backup
Merge requests
!30
Update docs
Code
Review changes
Check out branch
Download
Patches
Plain diff
Merged
Update docs
eliminate-scheduler
into
master
Overview
0
Commits
2
Pipelines
0
Changes
4
Merged
Hahn Axel (hahn)
requested to merge
eliminate-scheduler
into
master
3 years ago
Overview
0
Commits
2
Pipelines
0
Changes
4
Expand
0
0
Merge request reports
Viewing commit
2f9e9f78
Prev
Next
Show latest version
4 files
+
155
−
32
Inline
Compare changes
Side-by-side
Inline
Show whitespace changes
Show one file at a time
Files
4
Search (e.g. *.vue) (Ctrl+P)
2f9e9f78
update docs
· 2f9e9f78
Hahn Axel (hahn)
authored
3 years ago
docs/30_Configuration/10_Database.md
+
16
−
31
Options
# Basic settings for database backups #
# Basic settings #
There are 2 required values in the jobs/backup.job
There are 2 defaults:
```
```
text
dir-localdumps = /var/iml-backup
keep-days = 7
```
## dir-localdumps ##
{string}
The target directory for local dumps. It is used by
*
the database dump scripts
*
the transfer script to store the client backups
*
the restore script
This defines the backup target for sql dumps and how long they will be kept locally.
Below that one a directory for the service will be generated; inside that one the database dumbs with scheme name and timestamp, i.e
.
There is an optional value to define the target directory for archived dumps. This value is used for couchdb2 only
.
/var/iml-backup/mysql/mydatabase__20190827-2300.sql.gz
`dir-dbarchive = /var/localdumps/archive`
## keep-days ##
see
[
backup.job
](
50_File_backup.job.md
)
{integer}
## Backup sqlite ##
The number of days how long to keep dumps locally.
Sqlite files can be located anywhere in the filesystem. That's why the
cannot be located with an auto detection. You need to define them in
the file jobs/backup-dbfiles.job first.
Remark:
To make a database restore its dump must be located at this directory.
Per database file set a line with the
`sqlite = `
prefix
To restore an older database you need to restore the dump from the filke backup first.
If you have local Mysql daemon or Pgsql you can test it by starting
```
# dump all databases
sudo ./localdump.sh
```
text
sqlite = /var/lib/whatever/sqlite-database_01.db
sqlite = /var/lib/somewhere/else/db.sqlite
```
```
# show written files
find /var/iml-backup
```
see
[
backup-dbfiles.job
](
50_File_backup-dbfiles.job.md
)
Loading