search

twindb / undrop-for-innodb

TwinDB data recovery toolkit for MySQL/InnoDB
https://twindb.com
GNU General Public License v2.0
384 stars 148 forks source link

does this tool support recovering data from json fields? #34

Closed tiankai007 closed 1 year ago

tiankai007 commented 1 year ago

Excuse me, does this tool support recovering data from json fields? I use "./c_parser" to parse json error reporting structure exceptions. If I change the json column to longblob, it can be parsed, but the result is a string of abnormal characters, such as' 02110037000501005030005040005050050050070005080005090050A00050B00050C00050E000510000511000514000515000516005160051600 '. Can I solve this problem?

akuzminsky commented 1 year ago

The abnormal characters string is a HEX value of the long blob field. Try to UNHEX it to see if the original JSON is in there.