SimpleBackups

guides

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

Remote MySQL Database Backup/Dump

Latest Post

Remote MySQL Database Backup/Dump

November 5, 2021

Explanation of SSH Tunneling, what it is, how to use it, how to connect to mysql via ssh tunnel, and back up and restore MySQL databases using an SSH Tunnel with examples.

Read more →

Connect Intercom to Notion like rockstar

Connect Intercom to Notion like rockstar

November 1, 2021

How we built an Intercom app that writes support conversations into a Notion database, why we wanted one place for every request, and the code behind it.

Restore MongoDB Atlas Collection using MongoDB Compass

Restore MongoDB Atlas Collection using MongoDB Compass

October 6, 2021

So you already have your backup and decided to restore this on your MongoDB Atlas database? In this article, we will tackle how to restore a MongoDB Atlas Collection using MongoDB Compass.

The Ultimate PostgreSQL Database Backup Guide

The Ultimate PostgreSQL Database Backup Guide

June 9, 2021

A working PostgreSQL backup script, from pg_dump to an S3 upload and a cron schedule, plus the three gaps a shell script leaves open however well you write it.

The Ultimate MongoDB Database Backup Script

The Ultimate MongoDB Database Backup Script

June 8, 2021

Learn how to backup your MongoDB database and store it remotely on Amazon S3. This tutorial will show you how to automate the process using a shell script and Cron.

Docker Postgres Backup/Restore Guide (with examples)

Docker Postgres Backup/Restore Guide (with examples)

February 18, 2021

Learn how to back up and restore docker postgres databases, with plenty of examples and commands. Dump docker PostgreSQL db with ease and restore it.

Docker Container Backup/Restore Guide

Docker Container Backup/Restore Guide

February 17, 2021

Docker containers are disposable, but the data inside them is not. What to back up, when a container is worth backing up at all, and how to restore an image.

The Complete mongodump Guide (with examples)

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.

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.