Starting from SqlBak version 3 you can backup MySQL Server databases. SqlBak supports two ways to 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 a 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.
How to backup MySQL via phpMyAdmin using SqlBak
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 only accessible via phpMyAdmin.
MySQL Incremental Backups
There are two types of people: people who do back up their files, and people who need to start doing it.
If you are not backing up your MySQL databases yet, you should start before you lose your precious data.
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.
How to Enable Binary Log in Linux
Below is a short tutorial on how to enable binary log in Linux.
Prod and Dev: Sync Two MySQL databases – Easy!
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.
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 script 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.
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 the 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).
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: