From 1045a21fd5c62dfec6d83afdd2c621fb0a8f46ea Mon Sep 17 00:00:00 2001 From: Julien Dessaux Date: Sun, 16 Apr 2023 23:38:02 +0200 Subject: Fixed VACUUM INTO sqlite3 commands across various articles --- content/blog/freebsd/going-social-2.md | 2 +- content/blog/miscellaneous/sqlite-backups.md | 2 +- content/docs/adyxax.org/social/backups.md | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/content/blog/freebsd/going-social-2.md b/content/blog/freebsd/going-social-2.md index 537dfa9..ed35c31 100644 --- a/content/blog/freebsd/going-social-2.md +++ b/content/blog/freebsd/going-social-2.md @@ -200,7 +200,7 @@ Backups are configured with borg on my host `lore.adyxax.org` and stored on `yen - { name: gotosocial-data, path: "/jails/fedi/root/home/fedi/storage" } - name: gotosocial-db path: "/tmp/gotosocial.db" - pre_command: "echo 'VACUUM INTO \"/tmp/gotosocial.db\"'|sqlite3 /jails/fedi/root/home/fedi/sqlite.db" + pre_command: "echo \"VACUUM INTO '/tmp/gotosocial.db'\"|sqlite3 /jails/fedi/root/home/fedi/sqlite.db" post_command: "rm -f /tmp/gotosocial.db" ``` diff --git a/content/blog/miscellaneous/sqlite-backups.md b/content/blog/miscellaneous/sqlite-backups.md index 4cf9bae..48bdc82 100644 --- a/content/blog/miscellaneous/sqlite-backups.md +++ b/content/blog/miscellaneous/sqlite-backups.md @@ -27,7 +27,7 @@ If by chance you are using my [borg ansible role]({{< ref "docs/adyxax.org/backu ``` - name: srv-short-db path: "/tmp/short.db" - pre_command: "echo 'VACUUM INTO \"/tmp/short.db\"'|sqlite3 /srv/short-data/short.db" + pre_command: "echo \"VACUUM INTO '/tmp/short.db'\"|sqlite3 /srv/short-data/short.db" post_command: "rm -f /tmp/short.db" ``` diff --git a/content/docs/adyxax.org/social/backups.md b/content/docs/adyxax.org/social/backups.md index da28d25..2d6ba40 100644 --- a/content/docs/adyxax.org/social/backups.md +++ b/content/docs/adyxax.org/social/backups.md @@ -11,6 +11,6 @@ There is only on jobs : ```yaml - name: ktistec-db path: "/tmp/ktistec.db" - pre_command: "echo 'VACUUM INTO \"/tmp/ktistec.db\"'|sqlite3 /srv/ktistec-db/ktistec.db" + pre_command: "echo \"VACUUM INTO '/tmp/ktistec.db'\"|sqlite3 /srv/ktistec-db/ktistec.db" post_command: "rm -f /tmp/ktistec.db" ``` -- cgit v1.2.3