SimpleBackups

guides

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

Learn how to Create an Incremental MySQL Backup with SimpleBackups

Latest Post

Learn how to Create an Incremental MySQL Backup with SimpleBackups

October 18, 2022

Incremental MySQL backups are one option away in SimpleBackups. What they are, when a growing database calls for one, and where the full guide lives.

Read more →

How to Create an Incremental MySQL Backup

How to Create an Incremental MySQL Backup

September 22, 2022

Incremental MySQL backups copy only what changed since the last run. How the level-0 to level-6 chain works, how retention resets it, and how to set one up.

How to fix MySQL lost connection

How to fix MySQL lost connection

September 13, 2022

Fix MySQL error 2013, lost connection during a query or mysqldump, by raising wait_timeout, interactive_timeout and max_allowed_packet to workable values.

How to create, grant and show user permissions in MySQL

How to create, grant and show user permissions in MySQL

August 31, 2022

Create a MySQL user, grant and revoke privileges, and show the permissions already assigned. Every command you need, with examples you can copy and run.

How to show a list of all MYSQL databases

How to show a list of all MYSQL databases

August 30, 2022

List every MySQL database with SHOW DATABASES, mysqlshow, information_schema or a GUI client, and why a short list usually means a permissions problem.

Why You Should Trust Your Backups Without a 2nd Thought

Why You Should Trust Your Backups Without a 2nd Thought

August 26, 2022

Most people never check that a backup is valid. How notifications and anomaly detection tell you when a run went wrong, instead of leaving you to find out.

The Complete Redis Backup Guide (with examples)

The Complete Redis Backup Guide (with examples)

August 9, 2022

Learn how to use redis-cli to dump and restore redis database. Learn about the common errors and pitfalls in this complete guide having a lot of examples.

DigitalOcean Backups Explained

DigitalOcean Backups Explained

April 22, 2022

What DigitalOcean Backups actually does: weekly system-level snapshots of a Droplet, four retained periods, attached Volumes excluded, and when that is enough.

DigitalOcean Snapshot Pricing 2024

DigitalOcean Snapshot Pricing 2024

April 2, 2022

DigitalOcean Snapshots cost $0.06 per GB of snapshot size per month, billed on used storage rather than allocated. Worked examples, and how Backups differ.

The Data You Didn't Know You Need to Keep Safe

The Data You Didn't Know You Need to Keep Safe

January 18, 2022

Cloud storage is not a cloud storage backup. Why S3, Azure and Google Cloud still leave your files exposed, and what an actual backup of them looks like.