How to back up MySQL database to FTP server automatically?

Make a double protection for your important MySQL database is recommended by many experts. Upload the MySQL backup files to a remote FTP server is a good choice. You can restore your MySQL databases from the remote FTP server if the local host crashed.

Automatic Backup Scheduler for MySQL allows you upload the MySQL backup files to your remote FTP server automatically. It supports resume broken transfer, you can set up the transfer times and wait time for everytime, if the transfer still failed, the software will record the error information. And it supports Proxy Server.

Please follow the steps to automatically back up MySQL database and upload the backup files to the FTP server:

Please download and install the software Automatic Backup Scheduler for MySQL.

1. Launch the software Automatic Backup Scheduler for MySQL.
2. Create a task to Back up MySQL databases to the SQL files.
3. Enter the name of the task and the information of the source MySQL server.
4. Select the databases and items which you want to back up.
5. Set up the backup file options.

Please choose the option Upload backup files and Upload the backup files to a FTP server on Step 5 of the Task Wizard. Please click FTP Settings... to set up the FTP options.
To reduce the localhost disk usage, you can choose the option Delete the local backup files if successfully uploaded. To reduce more disk usage, you can choose Incremental Backup on Step 3 of the Task Wizard or compress the MySLQ backup files to ZIP/GZ on Step 4 of the Task Wizard.

Please enter the information of your FTP server. If you have no idea about the information, please contact your FTP provider.

1. FTP/SFTP: Select the type of you FTP server ( Support FTP, SFTP Private Key, SFTP Password, SFTP Password Private Key ).
2. Host name or IP: The host name or IP address of the FTP server.
3. Username: The username of the FTP server.
4. Remote Folder: The folder where store the MySQL backup files on FTP server. The folder must exist before uploading.
5. Password: The user's password of the FTP server. If you select a Private Key FTP server, it's not required.
6. Port: The port of the FTP server, the default port is 21.
7. Protocol: Support FTP ( standard ), FTPS ( Implint SSL/TLS ), FTPS ( Explint SSL/TLS ).
8. Data Connection: Support Passive ( PASV ) and Active ( PORT ) mode.
9. Private Key: The private key for loging in the FTP server. If you select a Password FTP server, it's not required.
10. Resume broken transfer: The software will try to upload the MyQL backup files to the FTP server some times and wait for some seconds each time if the first transfer is failed. If the transfer still failed, the software will give up and record the error information.
11. Use Proxy Server: If the FTP Server should communicated with Proxy Server, please check the option and set it. Read more...

After setting up the options, do not forget to check ftp connection by clicking Test Connection button.


Please click Next and choose the Task Scheduler for running the task on Step 7 of Task Wizard to upload the MySQL backup files to your FTP server on schedule.


Click Finish on Step 8 of Task Wizard to finish the task creation.

That's all. The software will automatically upload the backup files to your FTP server every time.