Omelchenko Alexander

How to Automate MySQL Database Backups in Linux

by

The solutions described in this blog post work for any Linux distribution: Ubuntu, Red Hat, Open SUSE, CentOS, Debian, Oracle Linux etcю However, the package installation commands may differ.

The automatic backup of MySQL Server databases is very important for preventing data loss. In order to properly automate backups, you must follow the following steps:

  1. Create a database backup
  2. Zip the backup
  3. Encrypt the compressed file
  4. Send the backup to Internet storage using FTP, Dropbox, AWS, Google Drive, etc.
  5. Receive email notification concerning backup results
  6. Create a backup schedule
  7. Delete old backups

Read more

Starting with SqlBak on Linux

by

The SqlBak application connects your Linux servers to sqlbak.com, allowing you to manage MySQL, PostgreSQL and MS SQL Server database backups from the web. It should successfully work on different Linux distributions such as Ubuntu, Debian, Fedora, CentOS and RHEL, but if you face any difficulty in using the app on your GNU/Linux distribution let us know.

Read more

SQL Server backup format: BAK vs SQB

by

SqlBak creates backups in the so-called .bak format, while RedGate’s product stores backups in .sqb format. What’s the difference?

Usually, database backup files with .bak extension contain data in the standard Microsoft Tape Format (MTF)  used by  Microsoft itself as well as many backup tools for the Microsoft Windows platform. Many third-party SQL Server backup products including SqlBak and SQLBackupAndFTP produce backups in this format as well.

Files with .sqb extension contain backups in RedGate’s proprietary format. You would need to use some special utilities if you want them to be converted into MTF. Let’s learn more about Microsoft Tape Format (MTF) and SQL Backup format from Red Gate.

Read more