1
Try dumping using --hex-blob
mysqldump --hex-blob test_db test > dump_test.sql
mysqldump --hex-blob --no-create-info test_db test > dump_test2.sql
Please let us know if the hex value remains the same between the two dumps.
UPDATE 2021-01-08 14:15 EST
Try changing character set
The MySQL Docs say that mysqldump will use utf8 if not specified
...
answered Jan 8 at 15:48
RolandoMySQLDBA
162k2626 gold badges268268 silver badges452452 bronze badges
Only top voted, non community-wiki answers of a minimum length are eligible
Related Tags
encoding × 117postgresql × 35
sql-server × 34
mysql × 28
collation × 24
character-set × 20
unicode × 20
utf-8 × 19
oracle × 11
t-sql × 7
import × 5
sql-server-2008 × 4
sql-server-2012 × 3
sql-server-2008-r2 × 3
mariadb × 3
xml × 3
mysql-5.6 × 2
ssis × 2
migration × 2
db2 × 2
mysqldump × 2
php × 2
configuration × 2
windows × 2
postgresql-9.4 × 2