How to export a table with binary data to a SQL file?

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.