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
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
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
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
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)
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
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
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
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
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…