SQLBackupAndFTP's blog | Page 2 | Effortless SQL Server backups

May 29, 2019

MySQL String Functions Cheat Sheet

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.

DOWNLOAD PDF

More…

May 15, 2019

MySQL backup error: unknown variable ‘column-statistics=0’

Reason

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). More…

February 6, 2019

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. More…

November 14, 2018

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. More…

July 2, 2018

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 SQL Server database from a backup copy using SqlBackupAndFtp. More…

May 23, 2018

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. More…

April 6, 2018

Service down alerts

If any live server goes offline, an administrator has to be notified. Many companies use some third party services to do that. But what if you SQL Server service crashed for some reason? Will you be notified right away or will find out after many lost sales and transactions? What if SQLBackupAndFTP itself crashed (while extremely rare, but everything happens) – how would you know your backups are not being done?

Service down alerts option in SQLBackupAndFTP covers all of these cases. If you enable it from the main screen (see the image on the right), an email will be sent to you in the following cases:

If your server is down or
If your SQL Server or MySQL is down or
If SQLBackupAndFTP service is down

If you need to email to multiple recipients – as usually, just separate it by a comma. You need a paid plan with Full-Service subscription to use this option.