My Oracle Support Banner

Export BIT and BLOB types to CSV/TSV with mysqldump (Doc ID 2651041.1)

Last updated on MARCH 20, 2020

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Goal

mysqldump has a --tab or -T option to create .sql files containing the structure and .txt files containing the data for each table. How can the binary data in BIT or BLOB fields be cleanly handled in those text files?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.