PostgreSQL doesn’t provide a built-in job scheduler like MS SQL, MySQL, and Oracle do. So if you need to run recurring tasks (like database backup), you have to use some other external tools like pgAgent, cron or pg_cron (on Linux), and Task Scheduler (on Windows). Let’s look at these options closer.
Here we are going to give you a short description of PostgreSQL string functions. If you prefer to have everything on one page, download our free PostgreSQL String Functions – Cheat Sheet. More…
Postgres provides three fundamentally different approaches for backing up its data:
Let’s discuss these methods one by one but if you prefer GUI tools you can use our free application to create database backups, which is, in essence, a powerful wrapper for pg_dump that creates SQL dumps. More…
During the backup you can get the following error message:
[SRV:8007#1326] Authorization failed. Computer name: <computer name>. Username: <user name>. Domain: <domain> > The user name or password is incorrect Computer name: <computer name> More...
The best way to protect your MySQL databases is to make scheduled backups. But is your method convenient and reliable? Assume you need to perform MySQL databases backups every 6 hours and then send them to the FTP Server? How much time will you spend every day in such a case? With the help of SQLBackupAndFTP, you can make MySQL backup in less than two minutes. More…
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…