SqlBak Blog

How to Automate PostgreSQL Database Backups in Linux

The solutions that are mentioned in this article work for any Linux distribution: Ubuntu, Red Hat, Open SUSE, CentOS, Debian, Oracle Linux, etc. However, the package installation commands may differ slightly.

The question of regular backups eventually comes up for any database management system. PostgreSQL is no exception. As a rule, the pg_dump utility, which is part of the PostgreSQL client, is used to create a hot backup.

Read more

How to Automate MySQL Database Backups in Linux

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

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