0

I need to extract a specific table from a large mysql dump file in order to restore it. I'm attempting this answer but I get this error: sed: RE error: illegal byte sequence. Could this be because of my blob image data that comes before the table I'm trying to extract? Is there a way around this?

gfrobenius
  • 3,987
  • 8
  • 34
  • 66
  • Never mind. This `LC_ALL=C` appears to have worked: https://stackoverflow.com/a/23584470/3112803 – gfrobenius Oct 09 '18 at 15:01
  • 1
    You can also consider using the `mysqldump --hex-blob` option. Refer to [mysqldump documentation](https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_hex-blob). – Bill Karwin Oct 09 '18 at 15:06

0 Answers0