Uncategorized

How to Enable Binary Logging for MySQL Server on Windows

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”.

More…

How to Schedule a Script via Windows Task Scheduler

A script can be run via the built-in Windows Task Scheduler tool. It can be found in the “Administrative Tools” section, or by clicking Win+R and typing taskschd.msc. Open the scheduler and in the “Actions” section select Create Task… More…

How to Restore SQL Server Backups

The conventional wisdom says: “Do not care about the backup of the database but about its recovery.” True, backups are created to be recovered, if necessary. In this article, we are going to see how to recover the SQL Server database from a backup copy using SQLBackupAndFTP. More…

How to backup SQL Server to Yandex Disk

yandex disk logoYandex.Disk is cloud storage from Yandex, the largest technology company in Russia (with 52% market share as a search engine). Yandex.Disk is a good alternative to Google Drive and its features and pricing policy are very similar to Google. More…

How to Automatically Backup phpMyAdmin

The fact is that hosting your website on a shared hosting most probably means that the only way to access your MySQL database would be through phpMyAdmin. Moreover, regular backups are still the most efficient way to protect your data, and making this process automatic with phpMyAdmin will make this routine much easier.

The good news is that SQLBackupAndFTP allows its users to backup their MySQL Server databases by connecting not only directly via TCP/IP, but also via the web interface of phpMyAdmin. Now, this process allows it to work for practically every website, including with the cheapest shared hosting. More…

How to Backup MySQL to Google Drive

Considering that today Google giant provides its users with a reasonably priced storage space featuring a user-friendly interface, why not consider backing up your MySQL Backups to Google Drive. The question here is that it is not at all convenient and efficient to continue sending your MySQL database backups made with mysqldump to Google Drive manually. But don’t worry, the solution is closer than you think – try using SQLBackupAndFTP. More…

Backup SQL Server on the network

SQLBackupAndFTP creates standard *.bak files when it runs locally on the same computer where SQL Server is. For remote SQL Server computer backups SQLBackupAndFTP creates backup script files (*.sql). Whenever possible, you should always opt for *.bak backups against *.sql backup files.

Here we will show you how to backup a SQL Server on the network to the standard *.bak file even when SQLBackupAndFTP runs on a different computer from where the SQL Server is. The main requirement, in this case, is that both SQL server and SQLBackupAndFTP have access to the same shared network folder.

More…

Cloud Databases for Busy People

This post will give you a bird’s eye view explanation of what “cloud database” is and what kinds of cloud databases the market offers us today. More…

SqlBackupAndFtp Discount Coupon

If you’re looking for a promo code for SQLBackupAndFTP you can use the following one:

SBF10OFF

It will give you 10% off all editions of SQLBackupAndFTP.

1 2