SimpleBackupsSimpleBackups

guides

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

PostgreSQL pg_dump & pg_restore Guide

Latest Post

PostgreSQL pg_dump & pg_restore Guide

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.

Read more

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 ...

How to restore a PostgreSQL backup

How to restore a PostgreSQL backup

October 23, 2020

There are different types of database aside from the commonly used MySQL database. You might work on a project that uses another type of dat...

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...

Extensive MySQL Common Errors List

Extensive MySQL Common Errors List

October 8, 2020

We review the most commond MySQL errors and how to fix them.

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 pre...

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 s...

Allow Remote MySQL Connections in cPanel

Allow Remote MySQL Connections in cPanel

June 10, 2020

Find out how to allow a remote IP to connect to your MySQL instance in cPanel.

Allow Remote MySQL Connections in WHM

Allow Remote MySQL Connections in WHM

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. Remo...

Restore a Linux File Backup

Restore a Linux File Backup

June 10, 2020

Download and restore a Linux file backup from a tar archive into a specific directory.