There is no --hex-blob option, so dumps are not valid text files

Database management in a single PHP file

Brought to you by: jakubvrana

#741 There is no --hex-blob option, so dumps are not valid text files

Milestone: Git

Status: open-accepted

Owner: nobody

Labels: None

Priority: 5

Updated: 2021-01-14

Created: 2020-02-26

Creator: Timothy Green

Private: No

A database which contains blob columns will produce invalid UTF-8 exports.

I would expexct the MySQL dump output to be a valid UTF-8-encoded text file, which means turning blobs into hexadecimal, instead of dumping the raw bytes into the file. The command-line tool has the --hex-blob switch, but Adminer does not seem to have anything similar.

Discussion

Jakub Vrána - 2020-03-06

status: open --> open-accepted
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Rob Starkey - 2021-01-14

Having this option would be really useful. Is there any update yet as to when it might be included? Thanks.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

There is no --hex-blob option, so dumps are not valid text files

Database management in a single PHP file

Group

Searches

Help

#741 There is no --hex-blob option, so dumps are not valid text files

Discussion