Exported data become unknown character May I know how to export MySQL data and prevent the data display a weird character?

This table uses to store the record about crawling information. It stores IP, PatternSignature, status, updated and PTR.



But whenever I export out the table, all the IP will become an unknown character which unable to import into database.



May I know how to rectify this issue?
Do not put that kind of data in VARCHAR or TEXT; use only VARBINARY or BLOB.  Please provide SHOW CREATE TABLE so we can discuss in more detail.

Use --hex-blob on mysqldump.

If you are "exporting" by some other means, explain.