You can find the SQLBackupAndFTP shortcut in the Windows Start menu in the SQLBackupAndFTP folder.
The Сonnect to Server form will open automatically or by clicking the gear button.
Select the DBMS type from the Server type list and set the connection parameters for the selected DBMS type.
Click Test Connection to verify the connection. If the connection succeeded, click Save & Close.
Click the gear button in the Select databases section and choose databases you want to backup by clicking checkboxes next to them in the list.
Or you can check Backup all non-system databases - this will automatically select all non-system databases.
This feature has an additional benefit - if new databases are created in the future, they will automatically be backed up. To exclude some databases from being automatically backed up add them to the Exclude databases list.
Click on any destination below for details:
Turn on Send confirmation.
On success email to (optional): emails will be sent to these recipients when the job is successful.
On failure email to: emails will be sent to these recipients if any error is encountered during the backup job.
Click the gear button for Advanced email settings
Click Run Now.
Verify that the appropriate people have received email messages.
Verify the target destinations contain backup files for each database.
If possible, test restoring these databases.
Turn on Schedule backups. Choose a time to do a full backup, usually during the night.
Click the gear button for Advanced schedule settings
All your backups can be found at the History & restore section. You can open a backup log by clicking Open Log, download backup file(s) by clicking Download Backup or restore the database from the backup by clicking Restore from Backup.
Web log shows the read-only history of backup jobs from your computers. It is available for licenses with active Full-Service subscription.
Just a single form to automate backups: select databases, backup, encrypt, compress, send to a folder, FTP or cloud service:
schedule backups, receive confirmation emails and restore when needed.
Features & Pricesfree- backup 2 databases to a network or FTP on schedule
$39+ backup 5 databases, Google Drive or Dropbox
$89+ unlimited database backups, OneDrive Personal & Box
$129+ Amazon S3, Windows Azure, OneDrive for Business & AES encryption
$499+ lifetime updates
There is a lot more to SQLBackupAndFTP than meets the eye. Below is a feature list for the tool.
SQLBackupAndFTP runs on Windows machines, and can backup both remote and local MySQL databases. Two database connection methods are available: via a TCP/IP (SSH) connection or by using phpMyAdmin Export. In both cases, it creates MySQL scripts that can be run later to restore the MySQL databases. When TCP/IP connection is used, the backup is performed using the mysqldump utility.
Previously, SQLBackupAndFTP and MySQLBackupFTP were two different products. MySQLBackupFTP has since been deprecated. Now SQLBackupAndFTP includes all the functionality of MySQLBackupFTP and more. SQLBackupAndFTP can restore MySQL backups. In addition, it can also notify you if something goes wrong with your MySQL servers.