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. Continue reading Export/Import SqlBak job in a .json file
Category Archives: Backups
SqlBak.Job.Cli.exe Reference Manual
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.
That tool can be used to register the application, manage connections to DBMS, and import jobs from .json configurations. Continue reading SqlBak.Job.Cli.exe Reference Manual
How to deploy SqlBak app automatically
When SqlBak is installed on a large number of servers, the deployment can be automated in 3 steps:
How to Automate MongoDB Database Backups in Linux
NoSQL databases allow us to redefine the way we interact with data. However, data protection requirements remain the same as for SQL databases.
One of the main ways to protect your data is to back it up regularly. This article will help you protect your data for the most popular NoSQL database – MongoDB.
Continue reading How to Automate MongoDB Database Backups in Linux
How to backup MySQL database on Windows
Because there are several ways to backup MySQL database on Windows, this article will review all the different options so that you can select the method that works for you. This article is limited to MySQL database backups for a Microsoft Windows Server only. If you are using a Linux-based OS, see How to Automate MySQL Database Backups in Linux.
How to send Log to developers
When you face any issues with SqlBak our support team may ask you to send the Advanced Log. Below is a short tutorial on how to do this. Continue reading How to send Log to developers
How to backup PostgreSQL with SqlBak
Starting from SqlBak app version 3 you can backup and restore your PostgreSQL databases. The SqlBak app creates the backups of PostgreSQL databases via pg_dump. Currently, only full database backups can be performed for PostgreSQL Server databases.
How to backup MySQL with SqlBak
Starting from SqlBak version 3 you can back up MySQL Server databases. SqlBak supports 2 ways on how you can 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 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
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 accessible via phpMyAdmin only. Continue reading How to backup MySQL via phpMyAdmin using SqlBak
MySQL Incremental Backups
“There are two types of people: people who do backup, and people who will start doing it.”
If you are not backing up your MySQL databases yet, you should start doing it before you lose your precious data.