Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No.: All

To export table with binary data to a SQL file, you may use the Data Transfer function.


Version 11.2 or below:

  1. Select Tools > Data Transfer.
  2. In the General tab, select the source connection, database and table, and choose Transfer to file / File.
  3. Choose a location for the file.
  4. In the Advanced tab, check Use hexadecimal format for BLOB.
  5. Click Start.


Version 12 or above:

Navicat always use hexadecimal format for BLOB when transferring tables to SQL files.


Have more questions?
Submit Ticket