In this article, we are going to talk about how to backup the MySQL databases. The easiest to backup MySQL database is to use the 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 databases. The first one is to use a 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: Continue reading How to Backup MySQL Database
All posts by Alex
MariaDB Backup and Restore Overview
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? Continue reading MariaDB Backup and Restore Overview
How to Backup MySQL to Dropbox
Nowadays it is very convenient to store database backups in the clouds. But how much time does it take to make a 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 that will make backups according to your schedule and then send them to Dropbox automatically. Continue reading How to Backup MySQL to Dropbox
How to backup MySQL to Azure Storage
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. Continue reading How to backup MySQL to Azure Storage
MySQL Auto Backup
If you are looking for a 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 the SQLBackupAndFTP application. Continue reading MySQL Auto Backup
How to Backup MySQL Databases
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.
Graphic materials
Please follow this link to download graphic materials.
How to backup PostgreSQL with SQLBackupAndFTP
Starting from SQLBackupAndFTP version 12.2, you can backup and restore PostgreSQL along with SQL Server and MySQL databases. SQLBackupAndFTP backups PostgreSQL databases using the standard pg_dump tool and, currently, it allows you to create full database backups only.
All you need is to create a backup job as you did before, with the only difference being that you have to select PostgreSQL Server as a server type when establishing the connection. If you have just started using SQLBackupAndFTP, here is a short tutorial on how to create a backup task to backup your PostgreSQL databases. Continue reading How to backup PostgreSQL with SQLBackupAndFTP
How to backup MySQL with SQLBackupAndFTP
With the release of SQLBackupAndFTP version 12, database administrators can now easily back up MySQL Server databases.
If you are already using SQLBackupAndFTP to back up SQL Server databases, you will be pleased to learn that the procedure to back up MySQL databases is almost identical. The only major difference is that you need to specify MySQL Server as the server type when you connect to the database server. SQLBackupAndFTP supports 2 methods for connecting to MySQL databases: TCP/IP and phpMyAdmin. TCP/IP (via port 3306) is the de-facto standard for connecting to a MySQL database server. Connecting via phpMyAdmin, on the other hand, is necessary if you don’t have direct access to your MySQL server, for instance. if your website is being hosted on a shared hosting platform.
SQLBackupAndFTP creates MySQL backups using the standard mysqldump utility. The utility creates a SQL script file that can be executed to reproduce the original database. At the moment, only full MySQL backups are supported by SQLBackupAndFTP.
If you’re new to SQLBackupAndFTP, below you can find a simple tutorial on how to backup MySQL databases. Continue reading How to backup MySQL with SQLBackupAndFTP
PowerShell how to backup and recover an SQL Server database FAQ
The following article will explain how to backup and restore databases in SQL Server using PowerShell. PowerShell is a very popular shell for operative systems used to automate tasks using the command line and scripts. PowerShell was created by Microsoft in Windows, but now it is supported in Linux and macOS also. Continue reading PowerShell how to backup and recover an SQL Server database FAQ