# wiki.limbosolutions.com

Welcome to public repository of my [wiki](https://wiki.limbosolutions.com).  
Using [media wiki](https://www.mediawiki.org/wiki/MediaWiki).  


## Requirements

- Docker
- Docker Compose
- Portainer (optional)
- [Duplicati Image with mySql client](https://git.limbosolutions.com/kb/duplicati/src/branch/main/docker/mysqlclient/README.md)


## Setup

[Docker Compose File](docker-compose.yaml)

## Backup and Restore

Using [custom duplicati image](https://git.limbosolutions.com/kb/duplicati) to daily backups files and databases. Every action (backup/restore) creates an log entry on docker.

### Duplicati - Default Options

Docker Log.

--run-script-after=dockerlog

### Duplicati - wiki job Options

Create db dump.  

run-script-before-required:duplicati-mysql-backup

### Restore Database

```bash
#select a file to import
ls /db-dumps
#select a file to import
DB_FILE= "file name to import"
mysql --host db -uroot -p ${MYSQL_DATABASE} < /db-dumps/$DB_FILE
#root password (root password is the enviromnent variable ${MYSQL_ROOT_PASSWORD})
```