Category Archives: Uncategorized

Automated SQL Server Backups to Amazon S3 on Windows

 Problem

The BACKUP DATABASE command syntax allows performing backups by specifying a drive, a network folder, or azure storage as the destination. Unfortunately, it is not possible to set an Amazon S3 bucket as a backup savepoint. However, it is possible to transfer the file to S3 using a batch script or a third-party utility.  Continue reading Automated SQL Server Backups to Amazon S3 on Windows

How to automatically upload MySQL backup to FTP on Linux

The first thing a DBA should do after deploying a database is to ensure that backups are created regularly.

But storing a backup file on the same server where the MySQL server is located would be a big mistake. Therefore, you should create a backup and put it out of the server on which MySQL is located. The simplest solution would be to transfer it to another server via FTP. Continue reading How to automatically upload MySQL backup to FTP on Linux

How to Find the Path to the MySQL Installation Directory on Windows and Add it to PATH Environment Variable

The main console utilities for working with MySQL are located in the directory where MySQL Server is installed. However, after installing MySQL Server, it is often difficult to find this directory. The best way is to add this path to your PATH environment variable, and then you can use MySQL and mysqldump utilities directly. Continue reading How to Find the Path to the MySQL Installation Directory on Windows and Add it to PATH Environment Variable

How to Automate MySQL Database Backups to S3

If you have an important database, then you need to make sure to back it up regularly. Preferably, you will make sure this happens automatically. But performing regular backups is only half the battle — you also have to consider where to store them. Saving the backups on the same server where the MySQL Server is installed isn’t safe, because if it crashes, you will lose everything. Continue reading How to Automate MySQL Database Backups to S3

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. Note, the package installation commands may differ slightly.

A question of regular backup sooner or later comes up for any DBMS. 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.

Continue reading How to Automate PostgreSQL Database Backups in Linux