SimpleBackups

The SimpleBackups Blog

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

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.

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

Hourly Amazon RDS MySQL Backups

Hourly Amazon RDS MySQL Backups

September 21, 2020

How to easily backup Amazon RDS database using SimpleBackups. You can schedule your first hourly backup in just 1 minute and store it where you want.

How to back up WordPress websites

How to back up WordPress websites

September 18, 2020

How to easily backup WordPress websites and database, using SimpleBackups. You can schedule your first backup in just 1 minute and store it where you want.

Product update - Backups the nice way!

Product update - Backups the nice way!

September 11, 2020

Product update - Website and database backups are becoming even easier to use! We released a new version of our backup solution including MysSQL, PostgreSQL, MongoDB and file backups improvements.

How to connect Wasabi

How to connect Wasabi

July 14, 2020

Connect Wasabi to SimpleBackups as a backup storage: create your bucket in the region you need, generate an access key, and store database and file backups.

How to connect DigitalOcean Spaces

How to connect DigitalOcean Spaces

July 14, 2020

Connect DigitalOcean Spaces to SimpleBackups as a backup storage: create the Space in the region you need, restrict file listing, and generate access keys.