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.
Category Archives: MySQL
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 accessible via phpMyAdmin only. Continue reading How to backup MySQL via phpMyAdmin using SqlBak
MySQL Incremental Backups
“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 yet, you should start doing it 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. Continue reading Incremental MySQL Server Backup via Binary Log
How to Enable Binary Log in Linux
Below is a short tutorial on how to enable binary log in Linux. Continue reading How to Enable Binary Log in Linux