SimpleBackups

guides

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

The Complete mongodump Guide (with examples)

Latest Post

The Complete mongodump Guide (with examples)

December 31, 2020

Learn how to use mongodump and mongorestore to dump and import monogodb collections, learn about the common errors and pitfalls in this complete guide having a lot of examples.

Read more →

The Complete mysqldump Guide (with examples)

The Complete mysqldump Guide (with examples)

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.

PostgreSQL pg_dump & pg_restore Guide

PostgreSQL pg_dump & pg_restore Guide

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.

How to Import an SQL File in MySQL

How to Import an SQL File in MySQL

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.

How to restore a PostgreSQL backup

How to restore a PostgreSQL backup

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.

How to Restore a MySQL Dump

How to Restore a MySQL Dump

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.

Extensive MySQL Common Errors List

Extensive MySQL Common Errors List

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.

Mounting DigitalOcean Spaces and Access Bucket From Droplet

Mounting DigitalOcean Spaces and Access Bucket From Droplet

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

Create DigitalOcean Spaces credentials

Create DigitalOcean Spaces credentials

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…

Allow Remote MySQL Connections in cPanel

Allow Remote MySQL Connections in cPanel

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.