How to Enable Binary Logging for MySQL Server on Windows

Uncategorized

To perform MySQL Server incremental backups, binary logs should be enabled and correctly set. Otherwise, you will see one of the following error messages:

Failed to backup “mysql” database with “Full” backup type: ​​​​​​​[DBMS-MYSQL:11015#1]​​​​​​​​​​ Unexpected binary log format. Current value: “MIXED”, expected value: “ROW”. Log in to the DBMS using the MySQL official client or other tools and run the statement to update the binary log format: set global binlog_format = ‘ROW’;

Failed to backup “mysql” database with “Incremental” backup type: ​​​​​​​​[DBMS-MYSQL:11014#1]​​​​​​​​ Binary log is not enabled. Current value of “log_bin” variable: “OFF”. Expected value: “ON”.

Continue reading How to Enable Binary Logging for MySQL Server on Windows →

MySQL Incremental Backups on Windows

backup, MySQL Server

Making a full database backup is very easy with mysqldump . Details are available in this article. However, such backups are a heavy load on the database because they require a lot of space and take a long time to create. This is not acceptable for a large production database. Therefore, instead of FULL database backups, you can do incremental database backups.

Incremental backups do not contain all database data but only the data that changed since the previous backup. In this case, to restore the data, you will need the entire chain of backups. Continue reading MySQL Incremental Backups on Windows →

Command Line Arguments to Manage an Installation

SQL Server, sqlbak.job.cli

Assume you need to clone your server and you have an image, for example, an AMI (Amazon Machine Image) in AWS with installed SQLBackupAndFTP Free edition. Once you deploy this image on several servers and apply your license key to activate SQLBackupAndFTP, that license key will be applied to all your servers. When you decide to remove your license from one of the servers, the license will be removed from all of them. Also, you can face the issue that the license will not work if you activate a license for one server on all your cloned servers. Continue reading Command Line Arguments to Manage an Installation →

Automating SQL Server Backups on Windows: Why You Need It and How to Do It

bak mssql, SQL Server

A backup is a copy of data taken and stored elsewhere so that you can restore it in case of a database breakdown. The most common causes of a breakdown include the following:

  • Hardware issue: The data in the database can get corrupted due to errors in the physical drives. However, it is not always physical damage to the server from the outside. Disks wear out, resulting in data read and write errors.
  • Software issue: As a rule, data is written to the database by a program, in which errors may occur and lead to data corruption after updates.
  • Human issue: A person with access might unintentionally damage the data. For example, they might delete data that was not supposed to be deleted. ​​
  • Hacker issue: If attackers infiltrate your system, then they will, first of all, encrypt your database and demand a ransom for decryption.

Continue reading Automating SQL Server Backups on Windows: Why You Need It and How to Do It →

How to Automate MySQL Database Backups in Windows

folder, reports

Preservation of data is an essential part of any business. Losing a database, such as a customer list, could effectively be the end of a company. The primary way to protect your data is to regularly back it up.

In this article, we will explain how to automate regular backups for MySQL on Windows. If you use Linux, check out this article: How to Automate MySQL Database Backups in Linux.

Continue reading How to Automate MySQL Database Backups in Windows →

How to clone SQL SERVER database to a Test Environment

folder, settings

It doesn’t matter if a company is large or small, almost every database administrator needs to maintain a copy of the production databases in a test environment for testing and development needs.

All you need to do for this is to copy the databases from the production server to a test server, and this can be done in different ways. Let’s take a look at them. Continue reading How to clone SQL SERVER database to a Test Environment →