As it is well known that the best way to protect your data safe and sound is to make regular backups. But what is the best way to backup database in MySQL? Of course, from one hand you can backup database in MySQL using Command Prompt (mysqldump) and from another hand, the best and the easiest way to backup database in MySQL is to use SQLBackupAndFTP tool. Now let’s learn how to backup database in MySQL using all three different methods. More…
If you are looking for the easiest way of how to backup MySQL to OneDrive we’d recommend you to use SQLBackupAndFTP utility. With the help of SQLBackupAndFTP, you can set up scheduled for making MySQL backups to OneDrive. All you need is to create a backup job which will create backups on a regular basis. Here we go: More…
Below we are going to show how you can easily restore your database from backup. MySQL database restoration process consists of two steps if you use Command Prompt, first, you need to create a new MySQL database and then restore a database. Or you can simply use SQLBackupAndFTP restore job. More…
In this article, we are going to talk about how to backup MySQL database. The easiest to backup MySQL database is to use simple GUI tool SQLBackupAndFTP. It is well known, that the best way to protect your MySQL database from any kind of failure is to create regular MySQL Server backups. Below we will cover the two most popular ways how to backup MySQL database. The first one is to use the third-party tool like SQLBackupAndFTP and the second is to make MySQL Server database backups with the help of mysqldump. So let’s start from the first method: More…
In this article, we are going to discuss some popular ways of MariaDB backup and restore. And the first question you can face using MariaDB is what is the difference between Logical and Physical backups? More…
Nowadays it is very convenient to store database backups in the clouds. But how much time does it take to make MySQL database backup and then sent it, let’s say, to Dropbox? With the help of SQLBackupAndFTP, you can do it in 2 minutes. Everything you need is to create a backup job which will make backups according to your schedule and then send them to Dropbox automatically. More…
You can perform MySQL Server database backups in many ways. Also, you can select a place where you prefer to store your backups. Assume you prefer to backup your MySQL Server to Azure Storage. But how much time does it take to create MySQL Server backup and then sent it to Azure Storage? Using SQLBackupAndFTP, you can perform a backup and then send it to Azure Storage in a few minutes. More…
If you are looking for MySQL auto backup tool then you can use SQLBackupAndFTP. It is really crucial to make MySQL backups on a regular basis. Do you really have to make MySQL auto backup and recovery? Sure. Unless you don’t care about your data or you are okay having to completely recreate your database in the event of a disaster, you need some way of restoring the database to a workable point. There are several ways how to perform MySQL Server backup and recovery, but the quickest is to use SQLBackupAndFTP application. More…
In this article, we are going to discuss how to backup MySQL databases with the help of SQLBackupAndFTP or using mysqldump. Organizing the backup process ought to be one of the components that are vital in the life of any DBA. Such a simple and easy procedure will definitely save you lots of time and effort in the future.
You don’t have to keep everything in mind. We have compiled a one-page-cheat-sheet that shows all MySQL string manipulation functions with examples. Enjoy.