aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJulien Dessaux2023-04-16 23:38:02 +0200
committerJulien Dessaux2023-04-16 23:38:02 +0200
commit1045a21fd5c62dfec6d83afdd2c621fb0a8f46ea (patch)
tree47b0a093c09b75a9ea65fe575f454d7a48267823
parentAdded wireguard on kubernetes part 1 blog article (diff)
downloadwww-1045a21fd5c62dfec6d83afdd2c621fb0a8f46ea.tar.gz
www-1045a21fd5c62dfec6d83afdd2c621fb0a8f46ea.tar.bz2
www-1045a21fd5c62dfec6d83afdd2c621fb0a8f46ea.zip
Fixed VACUUM INTO sqlite3 commands across various articles
-rw-r--r--content/blog/freebsd/going-social-2.md2
-rw-r--r--content/blog/miscellaneous/sqlite-backups.md2
-rw-r--r--content/docs/adyxax.org/social/backups.md2
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"
```