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.
Ivan Gusev
Managing the Database Backup of Multiple Servers
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.
Export/Import SqlBak job in a JSON file
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.
SqlBak.Job.Cli.exe reference manual
Disclaimer: This article applies only to Windows systems.
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.
How to backup SQL Server databases on Windows
This article looks at different ways to back up SQL Server, from classic and conventional to exotic and situational.
But first, a few words of theory.