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.
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.
With SqlBak you can create a backup job to run scheduled backups of MySQL, send the backups to their destinations, and if needed, restore them. Below is a step-by-step guide on how to automate your MySQL backups if it’s accessible via phpMyAdmin only. Continue reading How to backup MySQL via phpMyAdmin using SqlBak
“There are two types of people: people who do backup, and people who will start doing it.”
If you are not backing up your MySQL databases, you should, and do it before you lose all your precious data.
Making backups is important and necessary. However, if your database is large, then creating a backup will load the server, and the backup itself will consume storage space. In light of these considerations, many make backups once a day at night, or even worse, once a week on weekend! However, a failure can lead to losing data for a period of many hours. What if you want to make backups more often without overloading the server? Incremental backups can help you with this. Continue reading Incremental MySQL Server Backup via Binary Log
Below is a short tutorial on how to enable binary log in Linux. Continue reading How to Enable Binary Log in Linux
No matter what IT project you create, you always need a sandbox to conduct testing and development. If your product has a MySQL database, then you will need to create a database in development environment. Continue reading Prod and Dev: Sync two MySQL databases – easy!
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.
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