Category Archives: SqlBak

PostgreSQL DBMS – /bin/sh: 1: /usr/bin/psql: not found

If during setting up of SqlBak on Linux or during a backup job one of the following errors occurs:

PostgreSQL DBMS – /bin/sh: 1: /usr/bin/psql: not found
or
PostgreSQL DBMS – /bin/sh: 1: /usr/bin/pgdump: not found

it means that SqlBak app could not find the path to postgresql executables. By default, SqlBak looks for postgresql files in the /usr/bin/psql directory.  Continue reading PostgreSQL DBMS – /bin/sh: 1: /usr/bin/psql: not found

How to Automate MySQL Database Backups in Linux

Automated backup of MySQL databases can be a serious task. The proper way to automate backups involves the following steps:

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

Continue reading How to Automate MySQL Database Backups in Linux

How to backup and restore Microsoft Azure Cloud SQL Database

Microsoft Azure SQL Database is a managed cloud database from Microsoft. It runs on a cloud computing platform, and access to it is provided as a service. If you use SqlBak for managing your database backups and want to backup Microsoft Azure SQL Database as well, here you will find a step-by-step guide on how to do it. Continue reading How to backup and restore Microsoft Azure Cloud SQL Database