Category Archives: Backups

How to Automate MongoDB Database Backups in Linux

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.

Continue reading How to Automate MongoDB Database Backups in Linux

How to backup MySQL database on Windows

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.

Continue reading How to backup MySQL database on Windows

How to backup MySQL with SqlBak

Starting from SqlBak version 3 you can back up MySQL Server databases. SqlBak supports 2 ways on how you can connect to your MySQL databases: phpMyAdmin and TCP/IP. Below you can find a step-by-step tutorial on how to backup your MySQL Server database via TCP/IP connection. To backup MySQL Server databases, SqlBak uses the mysqldump utility. For now, with SqlBak on Windows, only full MySQL backups are available.

Continue reading How to backup MySQL with SqlBak

Incremental MySQL Server Backup via Binary Log

Making backups is necessary, but doing this with large databases may involve high server load and using up storage space. And only creating a backup once a day or once a week could lead to losing hours of work. So how can you make backups more often without overloading the server? Incremental backups can help you with this. Continue reading Incremental MySQL Server Backup via Binary Log

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