No matter what IT project you are creating, you will always need a sandbox for testing and development. If your product has a MySQL database, then you will need to create a database in a development environment. Continue reading Prod and Dev: Sync Two MySQL databases – Easy!
How to backup remote SQL Server database using SqlBak
With the help of SqlBak, you can backup your remote SQL Server databases according to your schedule. A standard BACKUP DATABASE command doesn’t work on a remote SQL Server, only scripts can be generated. If there is a choice between scripts generation or performing backups in *.bak files, it is always recommended to run the standard BACKUP DATABASE command to get *.bak files. Scripts have some drawbacks: they are larger and do not support differential and transaction log backups. A more detailed explanation about remote backups can be found in the following blog post.
Continue reading How to backup remote SQL Server database using SqlBak
How to backup and restore Amazon RDS SQL Server
Amazon RDS SQL Server is a cloud database from Amazon. The way RDS SQL Server performs backups is the main difference between this and classic SQL Server. It offers the following: snapshots, restore point-in-time, Export Data-tier Application, and native backup to S3, instead of native T-SQL BACKUP DATABASE construction.
Continue reading How to backup and restore Amazon RDS SQL Server
MySQL Backup Strategy
How to Copy SQL Server Databases from Windows to Linux
Now that Microsoft has released SQL Server for Linux, even if your main tech stack is tied to a Windows Server you may want to copy the database to another SQL Server located on a Linux computer. This can come in handy, for example, if you wanted to provide developers with a database for testing without buying a Windows Server license.
There are a few ways to tackle this task. This article examines the following methods to copy the SQL Server database from Windows to Linux:
- Using T-SQL’s BACKUP DATABASE and RESTORE DATABASE commands
- Generation of T-SQL database script (such as mysqldump)
- Creating BACPAC
- SqlBak service
Continue reading How to Copy SQL Server Databases from Windows to Linux
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 get app keys for OneDrive For Business
Below is a short step-by-step tutorial on how to get private keys for OneDrive for Business. Continue reading How to get app keys for OneDrive For Business
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
Jupyter Notebook Markdown Cheatsheet
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
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:
- Create a database backup
- Zip the backup
- Encrypt the compressed file
- Send the backup to Internet storage using FTP, Dropbox, AWS, Google Drive, etc.
- Receive email notification concerning backup results
- Create a backup schedule
- Delete old backups
Continue reading How to Automate MySQL Database Backups in Linux