MySQL Archives - SqlBak Blog

MySQL Point-in-Time Recovery (PITR)

November 10, 2022October 26, 2022 by Ivan Gusev

Point-in-time recovery is the concept of restoring data to a particular time in the past.

Suppose you deleted an important database table at 2 p.m. on a Wednesday. You realize this fifteen minutes later and you need to restore the data. Replication will do you no good, because the table in the replica has also been deleted. Only backups can save the day.

However, if you back up your data at 1 a.m. every day, the closest recovery point to when the table was deleted will be at 1 a.m. that Wednesday. When you restore data, you will lose 13 hours of data. But if you use the point-in-time recovery strategy, you can recover data as of 1:55 pm, losing only 5 minutes!

How to connect to MySQL Server using SSH key pairs

November 8, 2022February 16, 2022 by Ivan Gusev

In order to backup MySQL Server via SqlBak you have to set a connection via TCP/IP. In other words, SqlBak communicates with a database through port 3306.

Managing the Database Backup of Multiple Servers

November 8, 2022December 8, 2021 by Ivan Gusev

While making a database backup is not a difficult task, making one the correct way can be a little more involved. So if you’re new to the process, setting up and maintaining backups on multiple servers can initially seem intimidating.

There is no one-size-fits-all solution. Choosing a good solution depends on your individual architecture, resources and security requirements. In this article, we will discuss the main approaches to managing multiple database backups, and we’ll look at the pros and cons of each approach.

MySQL Maintenance Automation

January 25, 2023June 24, 2021 by Omelchenko Alexander

For the MySQL database to work quickly and without interruptions, it is necessary to perform maintenance jobs from time to time. This mostly just means running a few commands, but let’s address first things first.

How to automatically upload MySQL backup to FTP on Linux

January 25, 2023May 17, 2021 by Omelchenko Alexander

The first thing a DBA should do after deploying a database is to ensure that backups are created regularly.

But storing a backup file on the same server where the MySQL server is located would be a big mistake. Therefore, you should create a backup and put it out of the server on which MySQL is located. The simplest solution would be to transfer it to another server via FTP.

How to Find the Path to the MySQL Installation Directory on Windows and Add it to PATH Environment Variable

January 25, 2023April 6, 2021 by Omelchenko Alexander

The main console utilities for working with MySQL are located in the directory where MySQL Server is installed. However, after installing MySQL Server, it is often difficult to find this directory. The best way is to add this path to your PATH environment variable, and then you can use MySQL and mysqldump utilities directly.

How to backup MySQL with SqlBak

January 26, 2022November 29, 2020 by Omelchenko Alexander

Starting from SqlBak version 3 you can backup MySQL Server databases. SqlBak supports two ways to connect to your MySQL databases: phpMyAdmin and TCP/IP. Below you can find a step-by-step tutorial on how to backup your MySQL Server database via a TCP/IP connection. To backup MySQL Server databases, SqlBak uses the mysqldump utility. For now, with SqlBak on Windows, only full MySQL backups are available.

How to backup MySQL via phpMyAdmin using SqlBak

January 26, 2022November 28, 2020 by Omelchenko Alexander

With SqlBak you can create a backup job to run scheduled backups of MySQL, send the backups to their destinations and, if needed, restore them. Below is a step-by-step guide on how to automate your MySQL backups if it’s only accessible via phpMyAdmin.

MySQL Incremental Backups

September 9, 2022October 23, 2020 by Omelchenko Alexander

There are two types of people: people who do back up their files, and people who need to start doing it.

If you are not backing up your MySQL databases yet, you should start before you lose your precious data.

Incremental MySQL Server Backup via Binary Log

December 29, 2021October 21, 2020 by Omelchenko Alexander

Making backups is necessary, but doing this with large databases may involve high server load and using up storage space. And only creating a backup once a day or once a week could lead to losing hours of work. So how can you make backups more often without overloading the server? Incremental backups can help you with this.