To find these files, please follow these steps:
- Press win+r
- Enter
services.msc - Find MySQL service Continue reading Where to find my.ini, mysql.exe, mysqld.exe, mysqlbackup.exe on Windows
Category Archives: MySQL Server
MySQL Incremental Backups on Windows
Making a full database backup is very easy with mysqldump . Details are available in this article. However, such backups are a heavy load on the database because they require a lot of space and take a long time to create. This is not acceptable for a large production database. Therefore, instead of FULL database backups, you can do incremental database backups.
Incremental backups do not contain all database data but only the data that changed since the previous backup. In this case, to restore the data, you will need the entire chain of backups. Continue reading MySQL Incremental Backups on Windows
How to connect to MySQL Server using SSH key pairs
To backup MySQL Server via SQLBackupAndFTP, you have to establish a connection via TCP/IP. In other words, SQLBackupAndFTP connects to a database via port 3306.
Continue reading How to connect to MySQL Server using SSH key pairs
How to Backup MySQL to FTP Server
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. Continue reading How to Backup MySQL to FTP Server
Backup Database in MySQL
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 a database in MySQL? Of course, on one hand, you can backup a database in MySQL using Command Prompt (mysqldump) and from another hand, the best and the easiest way to backup a database in MySQL is to use the SQLBackupAndFTP tool. Now let’s learn how to backup a database in MySQL using all three different methods. Continue reading Backup Database in MySQL
How to Backup MySQL to OneDrive
If you are looking for the easiest way how to backup MySQL to OneDrive we’d recommend you to use SQLBackupAndFTP utility. With the help of SQLBackupAndFTP, you can set up schedules for making MySQL backups to OneDrive. All you need is to create a backup job that will create backups on a regular basis. Here we go: Continue reading How to Backup MySQL to OneDrive
How to restore MySQL Server backup
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. Continue reading How to restore MySQL Server backup
How to Backup MySQL Database
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
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