TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Ask HN: Where do you backup your local databases?

3 pointsby excitednumberabout 7 years ago
HN,<p>I have some at home projects that do not need to live on Google cloud or aws, and would only introduce costs in excess of running things locally.<p>I now have around 10gb of data (not a lot in this world) that I want to backup just in case something happens to my local box.<p>For code this problem is easy (git, bitbcuket etc). But for databases I am unclear.<p>What do people use? I could go the Google drive route, but I feel like there must be tons of options for a problem like this.<p>Thank you for any guidance.

2 comments

uptownabout 7 years ago
For things like this, I feel you&#x27;ve got three options.<p>You likely want your data offsite since your primary is onsite, so that means either a cloud provider (Google Drive, Amazon Drive, S3, etc.) which you can choose based on best-price, but as you mentioned, the downside is cost.<p>The second option is to find a friend or family with similar needs, and &quot;trade&quot; storage. You setup a NAS for them to write to. They setup a NAS for you to write to. You both encrypt everything and send it offsite. The upside of this approach is that it&#x27;s essentially free apart from the allocation of storage space. The downside is that friends and family may not be as reliable as a paid service.<p>A third option is to buy a cheap portable hard drive, and periodically perform backups. The downside of this approach is that it&#x27;s on you to perform this task regularly, and you&#x27;ll always have some gap between when your last snapshot was performed and this gap may be meaningful if this isn&#x27;t conducted with enough frequency.
评论 #17040413 未加载
znpyabout 7 years ago
3-2-1 rule: three copies, two of which live in the same place (one is the working copy, the other might be a snapshot on another machine or on a detachable hard drive) and the one off-site.<p>for he off-site, you might just want to go with S3, Backblaze&#x27;s B2 or mega.co.nz (free up to 50GB). Actually, many web-hosting company nowadays will happily provide you with 20+gb for as little as 20-50$&#x2F;year.<p>I just went and verify the last statement and turns out that hostgator will sell you unlimited hosting space: <a href="https:&#x2F;&#x2F;www.hostgator.com&#x2F;web-hosting" rel="nofollow">https:&#x2F;&#x2F;www.hostgator.com&#x2F;web-hosting</a>