SimpleBackups
/mysql

mysql

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

How to create a PlanetScale database backup

Latest Post

How to create a PlanetScale database backup

September 1, 2023

Master the Art of PlanetScale Database Backups: Step-by-Step Guide 🛡️ Discover the secrets to safeguarding your PlanetScale database with our comprehensive backup tutorial. Learn the step-by-step process to create rock-solid backups effortlessly. Protect your data with confidence!

Read more →

MySQL Database Security Best Practices: How to Protect Your Data From Cyber Threats?

MySQL Database Security Best Practices: How to Protect Your Data From Cyber Threats?

August 31, 2023

The best way to ensure your MySQL database is always safe is to use a third-party tool designed specifically for backups. This article delves into the complex MySQL environment and database security best practices.

4 Best MySQL Backup Tools: The Ultimate Comparison

4 Best MySQL Backup Tools: The Ultimate Comparison

August 10, 2023

Explore the top 4 MySQL backup tools in our ultimate comparison guide. Dive deep into features, ease-of-use, and reliability to choose the best solution for your database needs.

5 Best MySQL Backup Tools in 2024 – Free And Paid

5 Best MySQL Backup Tools in 2024 – Free And Paid

August 3, 2023

Looking for the Best MySQL Backup Tools? Discover top-rated solutions that ensure your data's safety. Click now to find the perfect tool for you!

Learn how to Create an Incremental MySQL Backup with SimpleBackups

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.

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.

Remote MySQL Database Backup/Dump

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.