MySql Backup FTP (MySqlBF) makes MySQL database backups and uploads them to FTP, Amazon S3, Dropbox, Box, OneDrive or Google Drive. Available in Free and Paid editions.

Detailed tutorial on how to setup MySqlBF

This is a very detailed tutorial. For most users it would probably be sufficient to go through titles and go into details only when something is unclear.

  1. Start MySQLBackupFTP
  2. Connect to MySql Server
  3. Select databases to backup
  4. Select where to store the backups (backup destinations)
  5. Set up notification e-mails
  6. Run the job
  7. Schedule the backup job
  8. Save the backup job
  9. Advanced Schedule (optional)

1. Start MySQLBackupFTP

You can find MySQLBackupFTP shortcut in the Windows Start menu in MySQLBackupFTP folder

Start Menu

2. Connect to MySql Server

Click the "Connect to MySql Server" button.

MySqlBF can connect to MySql server via TCP/IP (directly to MySql server) or using phpMyAdmin tools.

  • Connect via TCP/IP: Hostname: Enter the name of SQL server you are connecting to (like localhost or 127.0.0.1)
  • Connect using phpMyAdmin: phpMyAdmin URL: enter the Url you using for remote administration of your MySql server (like localhost:8080/phpMyAdmin
Click "Test Connection" to verify the connection. If the connection fails, then first use MySQL client application to connect to your database, then use exactly the same settings in MySqlBF.

Connection Button
Connect Dialog
Connect Dialog

3. Select databases to backup

Select databases you want to backup by checking them in the list. Or you can check "Backup all Non-System Databases" (below the "Connect to SQL Server" button) - 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.

Select databases

4. Select where to store the backups (backup destinations)

Click "Add backup destinations"

Store Local
 

Select one of the backup destinations where you would like to store the compressed backup files

Select Destinations

4a. Send backups to a Local/Network folder (optional)

If you chose to send backups to a "Local/Network Folder" then you will see this form.

You need to store the backup on a different physical drive than your databases reside or (better) on another computer. Choose the target folder (like \\backupserver\sqlbackups\ or D:\backups).
Note that the account which starts a scheduled job must have sufficient rights to write to the target folder (In Advanced settings you can set it to run under your own account).

Store Local

4b. Send Backups to FTP (optional)

If you chose to send backups to "FTP Server" - you will see this form.

On the "FTP Server" form specify how to connect to your FTP server. Like in any FTP client, you usually need to specify hostname, username and password. If FTP does not work for some reason, use any FTP client to connect to your server first, and then use the same settings here.

Ftp settings

4c. Send Backups to Dropbox (optional)

If you chose to send backups to "Dropbox" - you will see this form.

On the "Dropbox Settings" form you'll need to authorize the SQLBackupAndFTP application to access your Dropbox (only once). Click "Authorize..." button to open the Dropbox site in your browser, sign in to your Dropbox account and click "Allow". After that return to SQLBackupAndFTP and click "Finish".

Important! The backups will be stored in \Apps\mySqlBackupFtp\ folder in your Dropbox.

Dropbox
 

4d. Send Backups to Box (optional)

If you selected to send backups to "Box" - you will see this form.

On the "Box Settings" form you'll need to authorize SQLBackupAndFTP to access your Box. Click "Authorize..." to open Box authorization page in your browser, sign in your to Box account and click at "Allow" . On the next page you will see the field with authorization code. Copy it to the clipboard.

Box
 

After that return to SQLBackupAndFTP, paste the authorization code and click "OK" .

Box

After you are authorized, you can enter the path to a backup folder. SQLBackupAndFTP will create the folder if it does not exist.

Box

4e. Send Backups to Google Drive (optional)

If you selected to send backups to "Google Drive" - you will see this form.

On the "Google Drive Settings" form you'll need to authorize SQLBackupAndFTP to access your Google Drive. Click "Authorize..." to open Google authorization page in your browser, sign in your to Google account and click at "Allow" . On the next page you will see the field with authorization code. Copy it to the clipboard.

Google Drive
 

After that return to SQLBackupAndFTP, paste the authorization code and click "OK" .

Google Drive
 

After you are authorized, you can enter the path to a backup folder. SQLBackupAndFTP will create the folder if it does not exist.

Google Drive

4f. Send Backups to Amazon S3 (optional)

If you chose to send backups to a "Amazon S3" then you will see this form.

On the "Amazon S3 Settings" form you'll need to specify how to connect to your Amazon S3 account. Access Key and Secret Key can be found on "Security Credentials" page of your Amazon Web Services account. It is recommended that you create a separate bucket for your backups. You can create it on Amazon web site (in any region) or SQLBackupAndFTP will create it in US Standard region.

Amazon S3

4g. Send Backups to OneDrive (optional)

If you selected to send backups to "OneDrive" - you will see this form.

On the "OneDrive Settings" form you'll need to authorize SQLBackupAndFTP to access your OneDrive. Click "Authorize..." to open OneDrive authorization page in your browser, sign in your to OneDrive account and click at "Allow" . On the next page you will see the field with authorization code. Copy it to the clipboard.

SkyDrive
 

After that return to SQLBackupAndFTP, paste the authorization code and click "OK" .

SkyDrive
 

After you are authorized, you can enter the path to a backup folder. SQLBackupAndFTP will create the folder if it does not exist.

SkyDrive

4h. Send Backups to Azure Storage (optional)

If you selected to send backups to "Azure Storage" - you will see this form.

On the "Azure Storage Settings" form you'll need to specify how to connect to your Windows Azure Storage account. Account Name and Access Key can be found on Storage page of your Windows Azure Portal. Here you should enter Container Name for your backups. SQLBackupAndFTP will create containter if it does not exist.

Azure Storage

6. Set up notification e-mails

Check "Send e-mail confirmations".
On Success e-mail to (optional): e-mails will be sent to these recipients when the job is successful.
On Failure e-mail to : e-mails will be sent to these recipients if any error is encountered during the backup job

Send Email
 

On "E-mail Settings" form you may specify how you want your emails to be sent. If you are using a paid version - emails will be send through "Automatic" option (web service on SQLBackupAndFTP.com). In Free version "Automatic" service is complimentary for 7 days, then you need to change it to send emails through GMail or your own SMTP server.

Email Configuration

7. Run the job to test it

Click "Run Now". Verify that appropriate people have received email messages. Verify the target folders from "Local/Network Folder" or FTP server (if specified) contains a zip file for each database. If possible, test restoring these databases.

Run Now

8. Schedule the backup job

Check "Schedule this job". Choose a time to do full backup, usually during the night.

Schedule Job

9. Save the backup job

Press the Save button on the toolbar and name the job appropriately. It is better to store the job on the same computer, not on the network.

Save Job

10. Advanced Schedule (optional)

On this form you can schedule the job to run at any custom schedule (more often than once daily).

Advanced Backup