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
Category Archives: full 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.
[DBMS-MSSQL:11006#11007] MySQL backup error: unknown variable ‘column-statistics=0’
The following error message:
[DBMS-MSSQL:11006#11007] MySQL backup error: unknown variable ‘column-statistics=0’
means that the version of mysqldump utility used by SQLBackupAndFTP to create MySQL backup doesn’t support the –column-statistics parameter (it should be older than 8.0.2). Continue reading [DBMS-MSSQL:11006#11007] MySQL backup error: unknown variable ‘column-statistics=0’
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
How to Restore SQL Server Backups
The conventional wisdom says: “Do not care about the backup of the database but about its recovery.” True, backups are created to be recovered, if necessary. In this article, we are going to see how to recover the SQL Server database from a backup copy using SQLBackupAndFTP. Continue reading How to Restore SQL Server Backups
How to backup SQL Server to Yandex Disk
Yandex.Disk is cloud storage from Yandex, the largest technology company in Russia (with 52% market share as a search engine). Yandex.Disk is a good alternative to Google Drive and its features and pricing policy are very similar to Google. Continue reading How to backup SQL Server to Yandex Disk
Remote SQL Server backups explained
Remote SQL backups are complicated. We will explain why and show all the available options to make the backups anyway. Continue reading Remote SQL Server backups explained
How to Automatically Backup phpMyAdmin
The fact is that hosting your website on a shared hosting most probably means that the only way to access your MySQL database would be through phpMyAdmin. Moreover, regular backups are still the most efficient way to protect your data, and making this process automatic with phpMyAdmin will make this routine much easier.
The good news is that SQLBackupAndFTP allows its users to backup their MySQL Server databases by connecting not only directly via TCP/IP, but also via the web interface of phpMyAdmin. Now, this process allows it to work for practically every website, including with the cheapest shared hosting. Continue reading How to Automatically Backup phpMyAdmin
How to Backup MySQL to Google Drive
Considering that today Google giant provides its users with a reasonably priced storage space featuring a user-friendly interface, why not consider backing up your MySQL Backups to Google Drive. The question here is that it is not at all convenient and efficient to continue sending your MySQL database backups made with mysqldump to Google Drive manually. But don’t worry, the solution is closer than you think – try using SQLBackupAndFTP. Continue reading How to Backup MySQL to Google Drive