diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2024-04-30 08:31:13 +0200 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2024-04-30 08:31:13 +0200 |
| commit | 329fd4bcf6504c74e3906e51c6fc2124bc09cc02 (patch) | |
| tree | 11c6c56d404403eca1996e89aeb6a978b9d92237 /cli/README.md | |
| parent | 173555795adf6614dff33893b373f22542910675 (diff) | |
CLI database backup and restore (#6387)
* CLI database backup and restore
Can also be used to migrate from one database to another (e.g. MySQL to PostgreSQL) or to ease upgrade to a major PostgreSQL version (e.g. 15 to 16).
* +x
* Fix some cases
* Update to docker-compose-v2
* More documentation
Diffstat (limited to 'cli/README.md')
| -rw-r--r-- | cli/README.md | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/cli/README.md b/cli/README.md index 1ce70b5c1..366f456d5 100644 --- a/cli/README.md +++ b/cli/README.md @@ -121,6 +121,14 @@ cd /usr/share/FreshRSS ```sh cd /usr/share/FreshRSS +./cli/db-backup.php +# Back-up all users respective database to `data/users/*/backup.sqlite` + +./cli/db-restore.php --delete-backup --force-overwrite +# Restore all users respective database from `data/users/*/backup.sqlite` +# --delete-backup: delete `data/users/*/backup.sqlite` after successful import +# --force-overwrite: will clear the users respective database before import + ./cli/db-optimize.php --user username # Optimize database (reduces the size) for a given user (perform `OPTIMIZE TABLE` in MySQL, `VACUUM` in SQLite) ``` |