Jupyter Notebook is a great tool for data analysis. And one of its greatest features is that you can easily combine runnable code with rich-text annotations. Markdown cells that contain such annotations support both HTML and Markdown syntax. Continue reading Jupyter Notebook Markdown Cheatsheet
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
For the MySQL database to work quickly and without interruptions, it is necessary to perform maintenance jobs from time to time. This mostly just means running a few commands, but let’s address first things first. Continue reading MySQL Maintenance Automation
One of the primary responsibilities of the DBA is to create regular backups. However, maintenance of the database is not limited to this.
The mechanisms that enable a relational database to run fast are based on a complex storage system that degrades over time. It leads to a general database slowdown. Continue reading PostgreSQL Maintenance Automation
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
The average lifespan of an SD card on a Raspberry Pi is two years. It is impossible to predict the date of failure of an SD card accurately. However, if you perform a regular backup of data on the card, its potential failure ceases to be an issue.
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
NoSQL databases allow us to redefine the way we interact with data. However, data protection requirements remain the same as for SQL databases.
One of the main ways to protect your data is to back it up regularly. This article will help you protect your data for the most popular NoSQL database – MongoDB.
Because there are several ways to backup MySQL database on Windows, this article will review all the different options so that you can select the method that works for you. This article is limited to MySQL database backups for a Microsoft Windows Server only. If you are using a Linux-based OS, see How to Automate MySQL Database Backups in Linux.
When you face any issues with SqlBak our support team may ask you to send the Advanced Log. Below is a short tutorial on how to do this. Continue reading How to send Log to developers
Starting from SqlBak app version 3 you can backup and restore your PostgreSQL databases. The SqlBak app creates the backups of PostgreSQL databases via pg_dump. Currently, only full database backups can be performed for PostgreSQL Server databases.