SqlBak Documentation

Documentation for the SqlBak product is currently under development. We apologize for any inconvenience.

While the documentation is being finalized, you can reach out to us through our support service, and we will strive to respond to your inquiry within a few hours.

Below is a list of articles from our blog where you can find useful materials on using SqlBak:

Read more

How to enable script execution in SqlBak

SqlBak enables the execution of SQL scripts and Windows batch scripts within backup or maintenance jobs. By default, script execution is disabled for security reasons. When attempting to add a script to a job, an error message may appear:

Execution of <script type> is prohibited. To allow script execution, please enable the corresponding option in the SqlBak App security settings.

Read more

Over SSH – Remote MySQL Backup & Dump Transfer

What is SSH

SSH (Secure Shell) is a method of secure data transmission over a network.

Administrators often encounter it when connecting to a Linux server by entering the command ssh userName@hostAddress, which allows them to execute commands on the remote server.

However, it is primarily a protocol, and on top of it, you can not only transmit data but also create SSH tunnels, allowing applications to transfer data over SSH.

Read more

MySQL Command Line Backup: Top 5 CLI Utilities

Targeted at DBAs, this article offers an overview of CLI utilities for MySQL backup. The commands described can be implemented in Linux Shell (.sh) scripts, as well as in Windows cmd (.bat) and PowerShell (.ps1) scripts. In addition to creating backups, dumps and exporting data, we’ll also delve into MySQL restore commands.

The article presupposes the use of InnoDB, the default storage engine, enabling hot backups without server downtime. If not specified otherwise, you’re likely already using it. Typically, other engines would lock the tables or the entire DB during the backup.

Read more

MySQL: From Dumps to Restores

A MySQL dump is a file that contains SQL commands, which, when executed, would lead to the recreation of the MySQL database at the moment of the dump’s export. Essentially, a MySQL dump database is a logical MySQL backup database.

mysqldumpis a utility that creates a MySQL dump. It is part of MySQL and MariaDB and gets installed alongside the MySQL client.

Read more

如何在 Linux 中自动化 MySQL 数据库备份

本博客文章所述解决方案适用于任何 Linux 发行版:Ubuntu、Red Hat、Open SUSE、CentOS、Debian、Oracle Linux 等。然而,包安装命令可能会有所不同。
自动备份 MySQL 服务器数据库对于防止数据丢失至关重要。要正确自动化备份,您需要按照以下步骤执行:

  1. 创建数据库备份
  2. 压缩备份
  3. 加密压缩文件
  4. 使用 FTP、Dropbox、AWS、Google Drive 等将备份发送到云存储
  5. 收到备份结果的邮件通知
  6. 创建备份计划
  7. 删除旧备份

Read more