Automatically Back up BLOB fields from MySQL database

Do you have stored a lot of Text, Images and Binary data in your MySQL database? If the data are lost, it's a nightmare. You need to create some backups of these data on schedule for avoiding data-loss. All of the larger data stored in the BLOB fields in MySQL database. Back up BLOB from MySQL is a powerful Windows software works for MySQL Backup Solution. It will help you to automatically back up the BLOB fields from the local and remote MySQL databases. You can dump / export / extract / back up all of binary columns ( BLOB, TEXT, BINARY, BIT, VARCHAR, etc. ) to the SQL files and dump them using hexadecimal notation ( 0x0A0BEF0D... ). The software can be used to back up MySQL databases on Windows, Unix, Linux, Mac OS and all servers.

Key Features

1. All of binary fields ( BLOB, TEXT, BINARY, BIT, VARCHAR, etc. ) supported.
2. Ability to create Full Backup, Incremental Backup and Differential Backup.
3. Ability to install a Windows Service for scheduling backing up without any users logged in Windows.
4. Dump the binary data using text, binary or hexadecimal notation supported.
5. Compress the backup files for reducing disk usage.
6. Easy-to-use Windows GUI interface.
7. Automatic Back up MySQL with Scheduler.
8. Back up all items of MySQL ( Tablespaces, Databases, Tables, Views, Triggers, Stored Procedures, Functions, Events, Indexes, Primary Keys, Foreign Keys, etc. ).
9. Back up all character sets of MySQL ( Unicode, UTF8, etc. ).
10. Back up all table types of MySQL ( InnoDB, MyISAM, BDB, etc. ).
11. Back up all field types of MySQL ( BLOB, TEXT, VARCHAR, DATE, DECIMAL, etc. ).
12. Back up the newly-created and updated items ( CREATE, DELETE, etc. ).
13. Support connection via TCP/IP, SSL, SSH, Compression, Shared-Memory, Named Pipe, Socket protocols.

1. Runs under Windows 8/7/2008 Server/Vista/2003 Server/XP/2000 (32 bit and 64 bit).
2. Supports MySQL from 4.0 to the latest version (MySQL 4.0, 4.1, 5.0, 5.1, 5.5, 5.6, 6.0, etc.).
3. Supports MySQL servers run on all Operating Systems (Linux, UNIX, Windows, Ubuntu, etc.).

Create Task
Create a task to Back up MySQL databases to the SQL files.
Click to Enlarge

Advanced Options
Click Advanced Settings on Step 3.
Click to Enlarge

Advanced Settings
Click Advanced Settings to set up BLOB settings.
Click to Enlarge
Dump binary columns (BINARY, VARBINARY, BLOB, BIT) using hexadecimal notation.

Back up BLOB