Online Documentation for SQL Manager for MySQL

Setting BLOB options

BLOB options


In this group of options you can determine whether BLOB fields are not to be extracted, extracted as strings, or extracted into a separate file (available for DB2, InterBase/Firebird, MS SQL, Oracle destination servers). If the latter is selected, you also need to specify the File name (the *.blo file where the BLOB data will be stored) and the location of the file on your local machine using the btnSaveAs button.


Export as SQL Script - Setting BLOB options



Note: If you choose to save BLOB fields in a file then afterwards this data can be restored only by using the SQL Manager for MySQL SQL Script tool.


CheckBox Compress file

Check this option if you wish to compress the file containing BLOB data.



Define the desired compression level to be applied for the file: None, Fastest, Default, Best.


Click the Next button to proceed to the Selecting fields to export step of the wizard.