MySQL Point-in-Time Recovery (PITR)
SqlBak Blog
by Ivan Gusev
3w ago
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 reco ..read more
Visit website
About MySQL Server Incremental Backups in SqlBak
SqlBak Blog
by Ivan Gusev
3w ago
In order to create an incremental backup, SqlBak performs binary log file backups. What are binary logs? Binary logs are files into which MySQL Server writes all data change transactions. Typically, these files are stored in /var/lib/mysql/ on Linux or C:\ProgramData\MySQL\MySQL Server 5.6 Data on Windows. The list of all MySQL Server binlog files is stored in a special binlog.index file. The transactions are recorded in the last binlog file for all databases at once in binary format. However, they can be converted to SQL statements. Re-executing these SQL statements will restore the database ..read more
Visit website
MySQL Point-in-Time Recovery (PITR)
SqlBak Blog
by Ivan Gusev
3M ago
Point-in-time recovery is the concept of restoring data to a particular time in the past. Suppose you deleted an important database spreadsheet 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 replica of the spreadsheet 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 spreadsheet 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 ..read more
Visit website
About MySQL Server Incremental Backups in SqlBak
SqlBak Blog
by Ivan Gusev
3M ago
In order to create an incremental backup, SqlBak performs binary log file backups. What are binary logs? Binary logs are files into which MySQL Server writes all data change transactions. Typically, these files are stored in /var/lib/mysql/ on Linux or C:\ProgramData\MySQL\MySQL Server 5.6 Data on Windows. The list of all MySQL Server binlog files is stored in a special binlog.index file. The transactions are recorded in the last binlog file for all databases at once in binary format. However, they can be converted to SQL statements. Re-executing these SQL statements will restore the database ..read more
Visit website
5 ways to reduce SQL Server backup size
SqlBak Blog
by Ivan Gusev
9M ago
SQL Server backup is a page-by-page physical copy of the database files. And, generally, the size of a backup is about the size of the database. However, there are several ways to cut the backup size substantially. Reducing the backup size has the following benefits: More restore points — The smaller the backup size, the more you can save, and therefore you can make more restore points and choose a more suitable date to restore in case of failure. Less strain on network bandwidth — According to the 3-2-1 rule, you should keep one copy of the data outside your network — the smaller the back ..read more
Visit website
How to backup and restore SQL Server on Linux
SqlBak Blog
by Ivan Gusev
9M ago
In this article, we will describe how to create a backup of a SQL Server that is installed on Linux. How does SQL Server create a backup? You can create a SQL Server backup by running the T-SQL command BACKUP DATABASE.This command saves the backup file to a specified directory. SQL Server backups are created quickly because it requires just copying data from the database files to the backup file. When creating a backup, you do not need to stop SQL Server or switch it to single-user mode, and the database continues to work as usual during this operation. Tools To create a SQL Server database ba ..read more
Visit website
How to connect to MySQL Server using SSH key pairs
SqlBak Blog
by Ivan Gusev
9M ago
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. However, it may not be possible to connect to a database port directly for security reasons. Sharing a database port for external connections is a bad practice, and by default, MySQL Server disallows such connections. If the server on which your database is located supports SSH connections, then you can configure port forwarding of the MySQL Server to your local port via SSH. SqlBak will communicate with its local port 3306, and the SSH tunn ..read more
Visit website
Managing the Database Backup of Multiple Servers
SqlBak Blog
by Ivan Gusev
9M ago
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. Custom solution The first thing that comes to mind is to create a good backu ..read more
Visit website
Export/Import SqlBak job in a JSON file
SqlBak Blog
by Ivan Gusev
9M ago
Starting from SqlBak app version 3.2.9, you can export a job to a JSON file and then import it using the SqlBak.Job.Cli.exe utility. This functionality is needed primarily for automated deployment of the SqlBak application and backup jobs creation. A simple tutorial on how to do this is described in the following blog post: How to deploy SqlBak app automatically. Below you can find detailed instructions on how to export and import a job. There are also some general tips on how to create a universal job template for automated deployment of a backup job. Export job settings to a JSON file To exp ..read more
Visit website
SqlBak.Job.Cli.exe reference manual
SqlBak Blog
by Ivan Gusev
9M ago
The sqlbak.job.cli.exe utility is a programming interface for working with the SqlBak application. It is located in the root directory where the application is installed. This tool can be used to register the application, manage connections to DBMS, and import jobs from JSON configurations. Below you can find all the commands and parameters supported by the sqlbak.job.cli.exeutility. Registration of the Application (-install) Usage: SqlBak.Job.Cli.exe -install [--parameter-name=parameter-value] Purpose: Establish a connection of the SqlBak app to sqlbak.com. Required parameters: --secret-key ..read more
Visit website

Follow SqlBak Blog on Feedspot

Continue with Google
OR