October 23, 2020
How to restore a PostgreSQL backup with psql or pg_restore, which one your dump file needs, and how to fix the errors that stop a restore part-way through.
October 20, 2020
Learn how to restore a MySQL backup (dump) using a simple command, a different database, a different server, a different MySQL version, or a web-based tool.
October 8, 2020
How to read a MySQL error, from the error number and SQLSTATE through to the message, plus the ten errors we see most often and what actually causes each one.
June 11, 2020
Step by step how to mount a DigitalOcean Spaces Bucket, and access it as how you normally access folders on Linux. The instructions will pretty much work for other S3-compatible storage providers and of course, S3 as well
June 11, 2020
create an access key and a secret key for your DigitalOcean Spaces In this tutorial I will highlight the steps to follow and also provide some…
June 10, 2020
Allow a remote IP to reach your MySQL databases in cPanel: whitelist a single address under Remote MySQL, or use a wildcard to allow a whole IP range.
June 10, 2020
You could allow a remote IP to connect to your MySQL instance, let's say for backup or to access your database from your local machine. Remote connections to MySQL are disabled in WHM.
June 10, 2020
Restore a Linux file backup from a tar archive: get the raw download link, pull the archive onto your server with wget, and extract it into the right path.
June 10, 2020
Every DigitalOcean datacenter region and location, from New York to Sydney, which ones DigitalOcean treats as legacy, and which Droplet plans run in each.
