Learn how to Create an Incremental MySQL Backup with SimpleBackups

Latest Post

Learn how to Create an Incremental MySQL Backup with SimpleBackups

Save time, storage, resources with incremental backups Over time, MySQL databases can grow so large that they strain your server, which…

How to fix MySQL lost connection

How to fix MySQL lost connection

September 13, 2022

When running a long or complex query on MySQL you might encounter the error below: This error is often faced when running mysqldump on a…

How to create and grant permissions to a MySQL user

How to create and grant permissions to a MySQL user

August 31, 2022

In this tutorial, we'll describe the common tasks you'll have to deal with when managing access to a MySQL database. Access MySQL command…

How to show all MYSQL databases

How to show all MYSQL databases

August 30, 2022

In this post, I will show you how to list all databases on MySQL or MariaDB. There are multiple cases where theses commands will come in…

Remote MySQL Database Backup via SSH Tunneling

Remote MySQL Database Backup via SSH Tunneling

November 5, 2021

Once a MySQL server is set up, the first task on any database administrator’s list is to prepare for backups. To execute backups, sysadmins…

The Complete mysqldump Guide (with examples)

The Complete mysqldump Guide (with examples)

December 7, 2020

Databases are essential tools to collect and store mountains of data. All complex applications use them to store information. There are many…

Mini Guide: How to Import an SQL File in MySQL

Mini Guide: How to Import an SQL File in MySQL

November 21, 2020

Have you just begun to learn how to work with SQL files using MySQL? Maybe you feel a bit lost on how to import files with this tool…

How to restore a MySQL backup

How to restore a MySQL backup

October 20, 2020

You already have your backup and decided to restore this on your MySQL database? In this article, we will tackle how to restore a MySQL…

Extensive MySQL Common Errors List

Extensive MySQL Common Errors List

October 8, 2020

Errors or mistakes are common in any aspects, especially in development. Using MySQL or any database can't guarantee you an error-free…

The Ultimate MySQL Database Backup Script

The Ultimate MySQL Database Backup Script

June 9, 2020

Any database, needs a backup . This article is part of “The Ultimate Backup Script” series we are creating to provide you with database…