guides

News, tips, guides and tools by the creators of SimpleBackups web

mysql mongodb supabase postgresql storage digitalocean git redis server

The Ultimate MySQL Database Backup Script

June 9, 2020

A mysqldump script that backs up a MySQL database and uploads the dump to Amazon S3, scheduled with cron, with a video walking through every line of it.

Add SSH key after creating a DigitalOcean droplet

October 6, 2019

Locked out of a DigitalOcean Droplet with no SSH key? Snapshot it, build a new Droplet from that snapshot with a key you hold, and get your data back.

Allow a remote IP to connect to your Amazon RDS MySQL Instance

November 8, 2018

Open an Amazon RDS MySQL instance to a remote IP: find the security group behind the database, add an inbound rule on port 3306, then test the connection.

Google Cloud Storage Signed URLs — The Easy Way

November 3, 2018

One of the cool things that Google Cloud Storage supports is the AWS S3 interoperability mode. This mode allows you to use almost the same API used for AWS S3 to deal with Google Cloud Storage