
December 7, 2020
Learn how to use MySQLDump to dump and import mysql database, learn about the common errors and pitfalls in this complete guide having a lot of examples.

December 1, 2020
Extensive guide about pg_dump and pg_restore commands, how to use them to back up and restore postgresql databases (pg_dump + pg_restore examples), common pg_dump options and what they do, and common errors.

November 21, 2020
So you already have your backup and decided to restore this on your MySQL database? In this article, we will tackle how to import SQL files in MySQL using a couple of methods.

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.