About last night...
I discovered that my server ran out of memory and killed the database server process while it was performing a long-running #Friendica schema update, which corrupted the data, which prompted me to look into the daily backup I set up years ago... 1/4
Beko Pharm (deprecated)
•ouch.
Also getting only 1/4 😱
Hypolite Petovan
•Beko Pharm (deprecated)
•Hypolite Petovan
•Beko Pharm (deprecated)
•Hypolite Petovan
•Hypolite Petovan
•[November 24th] I then found out that:
- My daily backup didn't run since April 2019 because of a wrong file extension name in the configuration ("tar.lz" instead of expected "tar.lzma")
- The domain name of the offsite server I used to send backups to isn't registered anymore
But worse...
My web host's basic backup FTP quota is 100 GB which would be insufficient for my complete backup even if it was working, and that 2.6 GB would have been taken by GoPro videos I took with my ex and hosted on a long-defunct personal website. 😓
Task list:
... show more[November 26th] And
[November 24th] I then found out that:
- My daily backup didn't run since April 2019 because of a wrong file extension name in the configuration ("tar.lz" instead of expected "tar.lzma")
- The domain name of the offsite server I used to send backups to isn't registered anymore
But worse...
My web host's basic backup FTP quota is 100 GB which would be insufficient for my complete backup even if it was working, and that 2.6 GB would have been taken by GoPro videos I took with my ex and hosted on a long-defunct personal website. 😓
Task list:
[November 26th] And we're back online after yet more adventures in a just-sized web server, unfortunately the direct upgrades (more memory, SSD) are unavailable at my current web host. I tried Hetzner but their entry-level offer is overkill for my needs.
Hypolite Petovan
•Each individual step didn't require too much active time, but the multiple dumps each took several hours, the couple reimports attempts also were lengthy. I would say about 5 hours total over a full week between scouring the web for solutions to corrupted database, perusing MariaDB logs to check it was correctly functioning again, chasing rogue background tasks and crons, and deleting unused databases/server user.
But it did occupy a significant chunk of my thought space even when not actively working on it.